ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   RegExp - String in VBA (https://www.excelbanter.com/excel-programming/394016-regexp-string-vba.html)

MSK

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