Mandatory input box?

**bobaftt** · 03-06-2009, 09:16 AM

I was wondering if there were a way to make the following code mandatory. I thought the end would do it but the system seems to substitute in a generic desk code if none is entered.

Please Login or Register  to view this content.

**DonkeyOte** · 03-06-2009, 09:50 AM

Perhaps along the lines of:

Please Login or Register  to view this content.

**bobaftt** · 03-06-2009, 10:23 AM

well it has to accept alpha characters as the desk code is an individuals initials

**DonkeyOte** · 03-06-2009, 03:08 PM

Perhaps you need to rephrase your InputBox statement on that basis.

For more info. on Application.InputBox types check out: http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

You can employ a similar approach to that already outlined where you check the LEN of the entered string to check it is 3 chars and if not prompt the user (with option to Exit if preferred).