Macro to select data Validation List Item
 

Is there a way to have a selection made via code in a validation list.
I have a VL on merged cells L6:N6
I want to do this IF statement:
If Sheet2.Range("B3").Value = "ABC" Then Sheet2.Range("L6:N6").Value =
"ALPHABET"

Where ALPHABET is one of the items int he Validation List.

How can i achieve this?


--
Corey ....
The Silliest Question is generally
the one i forgot to ask.

Macro to select data Validation List Item
 

You should address a merge cell by the first location and not the entire range

If Sheet2.Range("B3").Value = "ABC" Then Sheet2.Range("L6").Value =
"ALPHABET"


"Corey" wrote:

Is there a way to have a selection made via code in a validation list.
I have a VL on merged cells L6:N6
I want to do this IF statement:
If Sheet2.Range("B3").Value = "ABC" Then Sheet2.Range("L6:N6").Value =
"ALPHABET"

Where ALPHABET is one of the items int he Validation List.

How can i achieve this?


--
Corey ....
The Silliest Question is generally
the one i forgot to ask.