Userform; text restrictions

  • Thread starter Thread starter jgmiddel
  • Start date Start date
J

jgmiddel

Hi,

I'm working with a VBA userform; in the fields are only digits and
letters allowed. How do I make this restriction?
 
There is no built in data validation capability. You would need to use code
to validate the data using the builtin events.

If, by chance, you have a textbox with a finite list of acceptable entries,
then you can replace that with a combobox.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

restrict user to enter 5 digits only 5
restrict textbox on userform to mm/yyyy 1
restrict users to input atleast five characters 3
userform program keeps crashing 4
VBA copy and paste data 2
Userform: text restrictions 2
Textbox values 4
How to transfer the data from userform to spreadsheet for specific dates 0

Back
Top