Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validate an account number
Given a general ledger account entered into a cell on the spreadsheet that
looks like: 123.123.1234.123456.123.12.123 Using VBA, I need to be sure it only contains either numbers or periods and no other stray characters (`,#$!-_=+ A-z ... etc), including blank spaces. What is the best way to test for this? Please note that I am already counting the periods to ensure the number of segments and checking the length of each segment... Thanks much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mask Account Number | Excel Discussion (Misc queries) | |||
Insert Name based on the account number | Excel Discussion (Misc queries) | |||
How account duplicated number if condition is met? | Excel Discussion (Misc queries) | |||
Validate values for Whole Number only | Excel Programming | |||
validate phone number | Excel Programming |