tdiscover
asked on
Check for special characters in vba for excel
I have a function that adds a new spreadsheet to the workbook and names it. I get the name from a textbox but I want to check for special characters that aren't allowed when naming a spreadsheet (e.g apostrophes). I don't know exactly what characters aren't allowed (I've only experimented with apostrophes so far). A good solution will help me check for all invalid characters from the textbox.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sweet! Thanks champion!
im glad i could help... :-)
game-master
just replace the "Folder" text to "Sheet"
i hope i could give u some idea..