Pop Up Window when text entered into cell

**kingdt** · 11-02-2006, 07:15 AM

I'm new to VB and what i want to do is to have a cell with a drop down box and 2 options, Yes and No, which i will do via the data - validation option.
When No is selected nothing happens but when Yes is selected i want a pop up window to appear with a message and an ok button.
Every row will have this option in the same column.
Is this possible?

**funkymonkUK** · 11-02-2006, 07:34 AM

What you need to do is create a validation rule on the cells you want then

open up VBE go to the worksheet that your vallidation is on in the code window select windows and the change type in what you want done.

I have attached an example for you.

Hope this helps you

**kingdt** · 11-02-2006, 08:37 AM

Thanks for that, but i have had a look at the worksheet and it doesn't seem to give me any pop up boxes when yes is selected. Am i missing something?

**funkymonkUK** · 11-02-2006, 08:44 AM

so you are able to select yes or no right if so then you have not enabled the macros.

check your macro security

tools>macro>macro security then make sure its on medium that way when you open a workbook it will ask if you want to enable or disable.
close excel

open the workbook again and try again but this time when it first opens it will ask you if you want to enable or disable macros choose enable macros.

**kingdt** · 11-02-2006, 08:55 AM

I'm using excel 97, don't know if that has anything to do with it. It ask's o enable macros when i open, put there are no macros attached that i can see.

**funkymonkUK** · 11-02-2006, 09:00 AM

no it should work with excel97.

I take it you are clicking on tools>macros>macros.. you will not see it listed there however if you right click on the tab at the bottom of the screen named sheet1 and then click view code you should see the code that runs when you select a value in column E it will not run if you change any other column other than E.