Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation in excel user form
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation in excel user form
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 "OssieMac" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation causing problems when using a data form in Excel 2 | Excel Worksheet Functions | |||
Data Validation - Drop Down for User Form | Excel Discussion (Misc queries) | |||
Date field in user form & Loading a user form on opening workbook | Excel Programming | |||
Excel: Filling a user form with yesterday's data | Excel Programming | |||
PASSING DATA FROM USER FORM TO EXCEL SPREADSHEET | Excel Programming |