Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unwanted characters in a TextBox
I have a TextBox where the user is supposed to enter a SSN and a macro that
will search through records on another spreadsheet in an effort to match the SSN. Sometimes users enters dashes in the SSN and sometimes they don't. However, all the SSN's in the records have the dashes in them. If someone enters a SSN without using dashes (or enters the dashes in the wrong place), how do I adjust the TextBox value so that it is also a "###-##-####" value just like the ones in the spreadsheet? Just having it formatted as a SSN won't work; it actually needs to be "###-##-####". Thanks all. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unwanted characters saving to fie | Excel Programming | |||
Removing unwanted characters | Excel Discussion (Misc queries) | |||
Removing unwanted characters | Excel Discussion (Misc queries) | |||
Removing unwanted characters | Excel Discussion (Misc queries) | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |