Pop up window
 

I would like a cell to be checked for a 2 letter code if a number is entered
to the right (next cell) of it, if the 2 letter code is not entered then a
window would pop up for a reminder.
How can I get a window to pop up with this message?
Is this possible?
Many Thanks

Kenny




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Pop up window
 

Kenny

You can use Data Validation. For instance if D9 contains the number and F9
contains the code, then you can use Data Validation in D9 like this

Allow: Custom
Formula: =AND(LEN(E9)=2,NOT(ISNUMBER(E9)))

then go to the Error Alert tab and type in whatever message you want.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com

"Kenny" wrote in message
...
I would like a cell to be checked for a 2 letter code if a number is
entered
to the right (next cell) of it, if the 2 letter code is not entered then a
window would pop up for a reminder.
How can I get a window to pop up with this message?
Is this possible?
Many Thanks

Kenny




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----