| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a Data validation list to select another validation l | New Users to Excel | |||
| How do I add an item with comma in the list of data validation | Excel Discussion (Misc queries) | |||
| DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING | Excel Worksheet Functions | |||
| How to use a macro to change the selected item in data validation | Excel Discussion (Misc queries) | |||
| Help! Selecting item on data validation list switches windows | Excel Discussion (Misc queries) | |||
Hybrid Mode
