Disallow "/" character from being entered

[jamer02]

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

[Colin Legg]

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.