Limiting Input Box Selections

**CJPHX** · 07-21-2010, 03:33 PM

I currently have an input box that asks for a user to enter their intials. Is there a way to make sure that the initials they entered are of a valid user. I only have about 6 people that use this. I would like it to check their input against the list and then if its not right make them enter them again.

Please Login or Register  to view this content.

Example: CJH, PHT, FXH, TOM

If the entry is not one of those then I would like it to ask them to input again.

Once the input is made it outputs to a log sheet for me.

Please Login or Register  to view this content.

I would then like a yes/no input box that asks them a question. If they enter yes I would like it to output to the log. If they enter no I want it to just continue on with the rest of the macro.

**davegugg** · 07-21-2010, 03:52 PM

The following code will accomplish what you are seeking:

Please Login or Register  to view this content.

You could also set up a custom form with a listbox with all your expected user's initials, and let them select them from the list.

**CJPHX** · 07-21-2010, 04:59 PM

I have tried to use the user form's before and I get some error about it not being available. I am hoping once my company upgrades to 2007 in the next few months it will be available.

**davegugg** · 07-21-2010, 05:10 PM

Here is an example with a userform and listbox. Does this now work on your machine?

**CJPHX** · 07-21-2010, 05:14 PM

It won't let me click on the show form button.

**davegugg** · 07-21-2010, 05:16 PM

Wow, I've never heard of a version of excel that doesn't allow the use of userforms.
Anyway, did the code I posted above work for you?

**CJPHX** · 07-21-2010, 05:27 PM

It has so far. I am trying to tweak it a little to work for the next box under it. I don't want to post that question under this one. Should I start a new thread? Or since it relates to the same thing post it here?