Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not allowing special characters in a cell
I want to do either "conditional formatting" or "data validation", I
think, so that users will not be able to enter special characters in a particular cell (/ * \ @, etc). There is a macro that saves the spreadsheet using the data in this cell as part of the file name. If they use certain special characters (such as slashes) it causes an error when they try and run the "file save" macro. However, I don't see how to bar the entering of specific characters using conditional formatting or data validation. How would I do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not allowing special characters in a cell
Perhaps use a worksheet event which checks the cell when it is entered and
"reports" on any errors. "TinaF" wrote: I want to do either "conditional formatting" or "data validation", I think, so that users will not be able to enter special characters in a particular cell (/ * \ @, etc). There is a macro that saves the spreadsheet using the data in this cell as part of the file name. If they use certain special characters (such as slashes) it causes an error when they try and run the "file save" macro. However, I don't see how to bar the entering of specific characters using conditional formatting or data validation. How would I do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not allowing special characters in a cell
In the macro that uses this cell for part of the filename you could strip the
special characters before using the information (or substitute acceptable characters). Will "TinaF" wrote: I want to do either "conditional formatting" or "data validation", I think, so that users will not be able to enter special characters in a particular cell (/ * \ @, etc). There is a macro that saves the spreadsheet using the data in this cell as part of the file name. If they use certain special characters (such as slashes) it causes an error when they try and run the "file save" macro. However, I don't see how to bar the entering of specific characters using conditional formatting or data validation. How would I do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not allowing special characters in a cell
To use data validation for this, make sure the cell you want is the active
cell. Select Data Validation. On the Settings tab, select Custom from the Allow combobox. Then, in the Formula box, you can enter something like: <"/" And < "\" And < "*" And < "@" And < "&" If the user types any of the specified characters in the cell, an error message (which you can customize) will be displayed when he/she presses Enter. Hope this helps, Hutch "TinaF" wrote: I want to do either "conditional formatting" or "data validation", I think, so that users will not be able to enter special characters in a particular cell (/ * \ @, etc). There is a macro that saves the spreadsheet using the data in this cell as part of the file name. If they use certain special characters (such as slashes) it causes an error when they try and run the "file save" macro. However, I don't see how to bar the entering of specific characters using conditional formatting or data validation. How would I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - Only Allowing certain characters | Excel Worksheet Functions | |||
MACRO PROBLEM - allowing only paste special | Excel Discussion (Misc queries) | |||
ALLOWING ONLY PASTE SPECIAL (URGENT) | Excel Discussion (Misc queries) | |||
How do I remove "special characters" from cell data? | Excel Discussion (Misc queries) | |||
Allowing the Legend Box to display more characters | Charts and Charting in Excel |