Link to home
Start Free TrialLog in
Avatar of tdiscover
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
Avatar of game-master
game-master
Flag of Philippines image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

just replace the "Folder" text to "Sheet"


i hope i could give u some idea..
Avatar of tdiscover
tdiscover

ASKER

Sweet! Thanks champion!

im glad i could help... :-)


game-master