Pop Up Message???

Parra · Mar 25th, 2002, 10:11 AM

I don't know if this is possible but I want a box with data to pop up everything a certain cell is activated.

For example when the cell A3 is activated I want a box that pops up and says Choose Department Marketing or Accounting. More like a reminder of what their options are.

I do not want to use a list or combo box, I want the user to type the information in.

Thanks

lenze · Mar 25th, 2002, 10:23 AM

The easiest way is to use the Input Message feature of Data Validation. You can choose to allow any value if you wish and still record an input message which will display when the cell is selected

Parra · Mar 25th, 2002, 10:39 AM

Thanks, Lenze it worked just the way I wanted.

Gracias

[ This Message was edited by: Parra on 2002-03-25 09:39 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 10:11 AM	#1
Parra Board Regular Join Date: Feb 2002 Location: Los Angeles, CA Posts: 752	I don't know if this is possible but I want a box with data to pop up everything a certain cell is activated. For example when the cell A3 is activated I want a box that pops up and says Choose Department Marketing or Accounting. More like a reminder of what their options are. I do not want to use a list or combo box, I want the user to type the information in. Thanks

Mar 25th, 2002, 10:23 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	The easiest way is to use the Input Message feature of Data Validation. You can choose to allow any value if you wish and still record an input message which will display when the cell is selected

Mar 25th, 2002, 10:39 AM	#3
Parra Board Regular Join Date: Feb 2002 Location: Los Angeles, CA Posts: 752	Thanks, Lenze it worked just the way I wanted. Gracias [ This Message was edited by: Parra on 2002-03-25 09:39 ]