Macro to select data Validation List Item

  • Thread starter Thread starter Corey
  • Start date Start date
C

Corey

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?
 
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"
 
Back
Top