View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default data validation in excel user form


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)

--
Regards,

OssieMac