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:
Thank you,![]()
If strNewWSName Like.........Then 'this is where I want to add those specail characters MsgBox Prompt:="Special Characters are not allowed as part of a worksheet name.", _ Buttons:=vbExclamation, Title:="" GoTo ShowInputBoxEnterNewWSName End If
BC
Bookmarks