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

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

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

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