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



wrote:

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.

--

Dave Peterson

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

Dave Peterson wrote:
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



wrote:

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.

--

Dave Peterson