Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combox Box - Need to Reference Named Range
I have a drop down menu in a Form,
I'd like to have it reference a specific name range in a sheet. I have a formula that creates the dynamic range automatically. let's say for example "dynRange" is the Name of it. I'd like to have a user double click the cell the form opens. And then they Can select two different drop downs and a certain value appears from that. Question: How do I reference a Named Range in a DropDown "Combo box" and what's the code/event procedure for if a user double clicks a cell, then I can do the open.form Thank you in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I change the reference to a named range via VBA? | Excel Programming | |||
reference first cell in a named range | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
named range, offset self-reference | Excel Discussion (Misc queries) | |||
Reference a named range | Excel Programming |