Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dropdown problem
I have a drop down on a DialogBox that looks up a range E4:E20. I
would like the user to add to this list. I have tried to get a reference to the new entry with for example:- DialogSheets("Email").DropDowns("Email_Address1a") .Value From the newsgroup I gather I need to reference the user entry ( "Value" is no use ) with some sort of indexing. Once I can get the new user entry to a variable I can add it to the list and even extend the range that is no problem. It is just getting the value the user typed... out?? Maybe I need to approach this from anther angle? Any help appreciated... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
Dropdown box display only data dependent on another dropdown box? | Excel Worksheet Functions | |||
Dropdown List within a dropdown | Excel Worksheet Functions | |||
offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
How do I create a dropdown within a dropdown? | Excel Discussion (Misc queries) |