Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell input mask
Is there a way to create an input mask for a cell to only allow the entry of
letters or numbers (no symbols)? And if the user enters a symbol, I need to display a message saying "Enter letters and numbers only." Any help will be GREATLY appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell input mask
You cannot check an entry while it is being made. Nor control what the user
can type. After it's entered you can check it. -- Jim "Dan N" wrote in message ... | Is there a way to create an input mask for a cell to only allow the entry of | letters or numbers (no symbols)? And if the user enters a symbol, I need to | display a message saying "Enter letters and numbers only." | | Any help will be GREATLY appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell input mask
How can the entry be checked after it is entered? Can that be done
automatically? Can I still display a message stating the violation (of entering symbols)? I only need to do this for one cell. Thanks for your response. - Dan N. "Jim Rech" wrote: You cannot check an entry while it is being made. Nor control what the user can type. After it's entered you can check it. -- Jim "Dan N" wrote in message ... | Is there a way to create an input mask for a cell to only allow the entry of | letters or numbers (no symbols)? And if the user enters a symbol, I need to | display a message saying "Enter letters and numbers only." | | Any help will be GREATLY appreciated. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell input mask
Use the Worksheet Change event. This article discusses the concept:
http://support.microsoft.com/kb/213373/en-us -- Jim "Dan N" wrote in message ... | How can the entry be checked after it is entered? Can that be done | automatically? Can I still display a message stating the violation (of | entering symbols)? I only need to do this for one cell. Thanks for your | response. | - Dan N. | | "Jim Rech" wrote: | | You cannot check an entry while it is being made. Nor control what the user | can type. After it's entered you can check it. | | -- | Jim | "Dan N" wrote in message | ... | | Is there a way to create an input mask for a cell to only allow the entry | of | | letters or numbers (no symbols)? And if the user enters a symbol, I need | to | | display a message saying "Enter letters and numbers only." | | | | Any help will be GREATLY appreciated. | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input mask for active cell | Excel Discussion (Misc queries) | |||
Can I set an input mask for a cell? | Excel Programming | |||
Can I set an input mask for a cell? | Excel Programming | |||
Input Mask | New Users to Excel | |||
Mask input in input boxes? | Excel Programming |