I have created a spreadsheet to place the Customers ID into and a games they have selected in the userform.
They can only do this 3 times so is there a way of only allowing this up to 3 times?
I have created a spreadsheet to place the Customers ID into and a games they have selected in the userform.
They can only do this 3 times so is there a way of only allowing this up to 3 times?
considering you haven't provided much information or an example this is the best you will get![VBA]
Dim IdCount as long
IdCount=Application.WorksheetFunction.=COUNTIF(Range("A1:A20"),"CUSTOMER ID HERE")
If IdCount>3 Then
MsgBox "ID Count Exceeded", "Registration Count"
End If
[/VBA]
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)