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.

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.

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.

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.
|
|
|