Validating data in a User Form

  • Thread starter Thread starter Jack Gillis
  • Start date Start date
J

Jack Gillis

I have created a User Form to enter data into an Excel Database using
text boxes. For one field (textbox) I would like to limit the user
input to three names, say AA, BB or CC.

I know how to do it on the worksheet and it works just fine. I can't
figure out how to do for the textbox for that field in the form.

Will someone give me a gentle shove in the right direction?

Thank you very much.
 
If you're going to limit it to three names, why use a TextBox? I'd use a
listbox or combobox loaded with the names instead.
 
OK. I guess I was going to use a text box on account of how that is
what is already there. No big deal, I can change it to a combo box.

Thank you.
 
Back
Top