View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MSK MSK is offline
external usenet poster
 
Posts: 1
Default 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.