Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am just trying to validate my controls using RegExp in VBA, My request is 1. Users are not allowed to enter any text which contains only special chars (either single char or 'n' chars) e.g. : ....................... or ///////////////////// or )))))))))))))))))) or *************** 2. Users are not allowed to enter any text which contains combination of the special characters e.g. : ............///////////$$$$$$$$ or (((((((()))))))){{{{{{{{ or ||||||||||||\\\\\\\\\??????? Basically users can enter Any text but length should be minimum 3 chars and They can use these special characters in between the text. e.g. 1 - This is test message -- given by Mr. M.S.K e.g. 2 - "Hello !!!!"- I am M.S.K(USA) What's the correct RegExp ? Thanks in advance MSK. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
regular expression parse string Perl $1 VBScript.RegExp | Excel Programming | |||
Is there any regexp and hashtable management in Excel VBA? | Excel Programming | |||
Declare RegExp from Vbscript.dll | Excel Programming | |||
RegExp to Parase File paths | Excel Programming | |||
How do you look for two distinct patterns (RegExp) | Excel Programming |