run code *after* drop down list choice

R

rcmail14872

I have a column of cells and each cell has data validation making the
user pick Yes or No from the drop down list. I would like my vba code
to run after *after* the user makes a choice of Yes or No.
For example, the user picks Yes, the cell the next column changes the
Pattern to light grey so it looks like the cell is greyed out.
 
D

Dave Peterson

You could use a worksheet_Change event, but it sounds like you could use
Format|Conditional formatting for this.

Say A2:Axx contains your yes/no cells.

Select B2:Bxx and use
Format|Conditional formatting
Formula is:
=$A2="Yes"
and give it a nice format
 
R

rcmail14872

SWEET ! you Rock D.P. Thank you very much.

Dave said:
You could use a worksheet_Change event, but it sounds like you could use
Format|Conditional formatting for this.

Say A2:Axx contains your yes/no cells.

Select B2:Bxx and use
Format|Conditional formatting
Formula is:
=$A2="Yes"
and give it a nice format
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pick from drop-down list gives empty or erroneous result 6
Data Validation List (conditional) 2
Colour-coding a cell from a drop down list 1
How to dynamically change the list in drop down list based on thevalue of another cell? 1
VBA drop down list help 3
Data Validation Drop Down Using VBA? 1
Excel Excel: How do I put a formula in a drop down list 11
Drop Down List and macros 3

Top