Stunasmearse
New Member
- Joined
- Jul 12, 2016
- Messages
- 13
Ask Question
Ask Question
<tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">
[TD="class: votecell"]
[TD="class: postcell"] I thought this would be an easy one, but I must be overlooking something and I have had no luck searching. I have a basic shared workbook for a sports day sign up. In column B the members select which sport they wish to play. I am trying to create a pop up message to appear for when the number of people enter "Soccer" in column B exceed 15. The column range is between B5:B200. I have the following but its not working. As always any help is greatly appreciated.
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; white-space: inherit;">
</code>
[/TD]
</tbody>
Ask Question
<tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline;">
[TD="class: votecell"]
up vote1down votefavorite
[/TD]
[TD="class: postcell"] I thought this would be an easy one, but I must be overlooking something and I have had no luck searching. I have a basic shared workbook for a sports day sign up. In column B the members select which sport they wish to play. I am trying to create a pop up message to appear for when the number of people enter "Soccer" in column B exceed 15. The column range is between B5:B200. I have the following but its not working. As always any help is greatly appreciated.
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; white-space: inherit;">
Code:
</code>Private Sub Worksheet_Change(ByVal Target As Range)<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; white-space: inherit;">Set Target = Me.Range("B5:B200")
If Target.Value = "SOCCER" > 15 Then
MsgBox "You have exceeded the 15 Players limit, please select another sport"
End If
End Sub
[/TD]
</tbody>