data validation in excel user form

  • Thread starter Thread starter sam
  • Start date Start date
S

sam

Hi All,

I have a user form with multiple text fields accepting numeric values,
character values, mix of numbers and alphabets, decimal values, etc.
How can I mark certain fields in user form to accept just the numbers,
alphabets, etc.

Thanks in Advance.
 
Hi Sam,

Need code to validate the entries. However, need a spec for each textbox
before writing the code. Spec info required.

Name of each textbox with following info.
Valid characters. (All numeric, all alpha, numeric/alpha)
If numeric/alpha is it a set number of numeric and alpha or random.
If random are all alpha together and all numeric together or mixed.
Describe set numeric/alpha as ####@@@@@ (for 4 numeric and 5 alpha.)
Alpha characters (if Uppercase,Lowercase or does not matter)
 
Thanks for the help OssieMac,

Can you show me an example of just numeric and just alpha?

Lets say the Text box Name is FirstName and for numeric CellPhone. Can I not
do it through the properties of a field from the user form?

Thanks in Advance
 
Back
Top