Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Also posted he 'VBA Express Forum' (http://www.vbaexpress.com/forum/showthread.php?t=27363) Hi all i'm using regex (provided for me by some one else because i don't have the foggiest with it) to force an entry of letters (at least for the first two, rather than all numeric, however i want the user to be able to enter the data in this fashion xxxxxx, xxxxxx where x will be a character, however, using this ^[a-z]{2}[a-z ]*$ does not allow the comma, can someone help modify it to accept it? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=110364 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Replace Comma's with Dash | Excel Worksheet Functions | |||
Excel do not accept any comma's (,) making them unusable... Help! | Excel Worksheet Functions | |||
Removing Comma's | Excel Programming | |||
Removing Comma's | Excel Programming | |||
ComboBox properties---need to recognize comma's in numgers | Excel Programming |