Like Operator in Simple Macro

[boldcode]

Hi,

I want to use the Like Operator within an IF Statement. I created some code below that if a user tries to name a new worksheet using the these characters

:\/?*[]

then my message custom error message will come up.

Here is my code below:

Please Login or Register  to view this content.

Thank you,

BC

[JapanDave]

This maybe,

Please Login or Register  to view this content.

[MarvinP]

Hi,

See if http://www.bettersolutions.com/vba/V...T218312322.htm explains how to do individual character matches using VBA.

[Leith Ross]

Hello boldcode,

The best method is to use Regular Expressions when checking for multiple characters. This macro will return True Or False after testing the file name for special characters. True if there are no invalid characters or False if there are.

Please Login or Register  to view this content.

[boldcode]

Hi Leith,

How do I use your function within my if statement? The reason I ask is because I expanded my macro into multiple if statements as shown below:

Please Login or Register  to view this content.

I appreciate the help!

[boldcode]

JapanDave,

Thank you very much, your code works!

- BC

[boldcode]

MarvinP,

Thank you, I will check out the link.

- BC

[jindon]

Just change the line

Please Login or Register  to view this content.

[boldcode]

jindon,

Awesome, thank you!

- BC

[boldcode]

Leith Ross,

Thank you again, I marked the post as Solved.

- BC