Hello,
I am using an Application.InputBox when the workbook is opened to prompt the user to input the their initials. These initials are used in other modules throughout the workbook. I added a While loop to keep prompting the user to enter a valid string which is working, but I still get errors if they click "Cancel" on the InputBox. Is there a way I can either keep the user from clicking "Cancel" or at least continue to prompt them to enter their initials if they do?
Private Sub Workbook_Open()
Enterinitials = Application.InputBox("Please Enter Your Initials", "Welcome", Type:=2)
While Len(Enterinitials) = 0
Enterinitials = Application.InputBox("Enter Valid Initials", Type:=2)
Wend
MsgBox "Thank you " & Enterinitials
End Sub
Thank you!
Bookmarks