Hi all,
I have a spreadsheet which has a login userform and is password protected. one of the button I have within the sheet once you have logged in is the ability to add a user with certain access rights so they can also login if you wish.
The userform is complete but I'm having trouble with the code (apologies the code is quite long) my 4 textboxes are the NewUseName, NewUseEmail, NewUseID and NewUsePassword, with the two option buttons determining which access to give to the new user.
I'm trying to get my code to read the contents of all 4 textboxes, if any of the boxes are empty and option 1 is selected then it will return a message box advising not all the fields have been completed (as they are all required), and then the same for option 2 being selected, any field empty display a message advising fields not completed, so long as all fields are completed, add the user!
I tried stringing all the textboxes together at the start with the:
If OptionButton1.Value = True And NewUseName & NewUseBRID & NewUseName & NewUsePass <> "" Then
but this only returns the message box for option 1 and only looks for the NewUseName being empty, not the other boxes!
Thanks in advance!
Bookmarks