Macro to select data Validation List Item

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?
 
J

Joel

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"
 

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

Multi macro inputs 5
4 Macro inputs, 1 out 2
Excell to Web Form filling macro 0
Need a macro to Copy data from one sheet and paste to child 3
Refering to a particular cell in a Named Range 3
Datavalidation with shrinking non blank values 1
Validation List 1
Data Validation -> Validation list is larger than the cell width 1

Top