run code *after* drop down list choice

  • Thread starter Thread starter rcmail14872
  • Start date Start date
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.
 
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
 
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...
 
Back
Top