Hey guys,
I wonder if anyone could help me.
I am looking to stop a user typing the "/" character into cell C17 on my spreadsheet, as when a macro is run, it uses this cell to name the file when saving, and windows doesn't allow this character in a file name, hence the macro crashes.
Can anyone help me please?
Thanks
Jamer
Hi Jamer,
You could set up a custom data validation rule in the cell like this:
=ISERROR(SEARCH("/",$C$17))
Btw, you could check the cell does not contain "/" in your VBA code by using the InStr() function.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks