![]() |
RegExp - String in VBA
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. |
All times are GMT +1. The time now is 09:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com