Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add additional cities to this drop down?
I have a drop down and can not find a sub script that allows me to add
additional entries into it. what would I be looking for? I thought I had opened all macros including the form that the drop down is in. A swift kick here might help! using Excel 2000. working a program that I didnt write just trying to update it and get it released. finally got around the link issue and have a good copy to work from. -- DStrider ITIL Certified |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add additional cities to this drop down?
If your "Drop Down" is a ComboBox, then check out the AddItem method in VBA
help file. The AddItem method only works if the original list is loaded using AddItem or List methods. Otherwise, if it uses RowSource, then you have to modify the RowSource to add items. "Strider" wrote: I have a drop down and can not find a sub script that allows me to add additional entries into it. what would I be looking for? I thought I had opened all macros including the form that the drop down is in. A swift kick here might help! using Excel 2000. working a program that I didnt write just trying to update it and get it released. finally got around the link issue and have a good copy to work from. -- DStrider ITIL Certified |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add additional cities to this drop down?
Maybe you can use a dynamic range that grows and contracts with the data:
Debra Dalgleish explains dynamic range names he http://contextures.com/xlNames01.html#Dynamic Strider wrote: I have a drop down and can not find a sub script that allows me to add additional entries into it. what would I be looking for? I thought I had opened all macros including the form that the drop down is in. A swift kick here might help! using Excel 2000. working a program that I didnt write just trying to update it and get it released. finally got around the link issue and have a good copy to work from. -- DStrider ITIL Certified -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add additional cities to this drop down?
Thanks for the input link was somewhat helpful have saved it for future
reference. however; I found this little diddy and believe that by fixing this it might allow me to adjust the field lookup up. suggestions, this program has been a nightmare. =IF(STEPONE!N6<"",CONCATENATE(STEPONE!N6," (",VLOOKUP(STEPONE!N6,ZoneTbl,6),")"),"") -- DStrider ITIL Certified "Dave Peterson" wrote: Maybe you can use a dynamic range that grows and contracts with the data: Debra Dalgleish explains dynamic range names he http://contextures.com/xlNames01.html#Dynamic Strider wrote: I have a drop down and can not find a sub script that allows me to add additional entries into it. what would I be looking for? I thought I had opened all macros including the form that the drop down is in. A swift kick here might help! using Excel 2000. working a program that I didnt write just trying to update it and get it released. finally got around the link issue and have a good copy to work from. -- DStrider ITIL Certified -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Zip codes and Cities | Excel Discussion (Misc queries) | |||
Drop-down menu and additional sheets | Excel Discussion (Misc queries) | |||
A Tale of Two Cities- Find and add | Excel Programming | |||
calculate km's between two cities | Excel Discussion (Misc queries) | |||
How do I insert map detail to a map? I.e. Cities, countries etc. | Excel Discussion (Misc queries) |