| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! =----- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! =----- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to save a desired window size but hv window comeup fullsz by d | Excel Discussion (Misc queries) | |||
| View cell contents as a pop-up window (similar to comments window) | Excel Worksheet Functions | |||
| Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
| The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
| How do I undo the Excel, Window Menu, New Window command | Excel Discussion (Misc queries) | |||
Hybrid Mode
