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,
Please Login or Register to view this content.
BC
Last edited by boldcode; 04-22-2013 at 10:40 PM. Reason: Solved
This maybe,
Please Login or Register to view this content.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
Hi,
See if http://www.bettersolutions.com/vba/V...T218312322.htm explains how to do individual character matches using VBA.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
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.
Last edited by Leith Ross; 04-22-2013 at 09:05 PM.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
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:
I appreciate the help!Please Login or Register to view this content.
JapanDave,
Thank you very much, your code works!
- BC
MarvinP,
Thank you, I will check out the link.
- BC
Just change the line
Please Login or Register to view this content.
jindon,
Awesome, thank you!
- BC
Leith Ross,
Thank you again, I marked the post as Solved.
- BC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks