How do I add to my drop down list? And how to I create a box to update my
drop down lists<

I am relatively new to this myself.

From what I have read, the list must be in the same worksheet. I
usually put my lists in row one as a horizontal list. Since a
worksheet can have 256 columns, this gives room for a fairly large
list, or several smaller lists. I have used as many as three rows for
my lists. I then hide that row or those rows.

For instance I will use the list $A$1:$Z$1 even though I myght only
have 15 items in the list. Then I can add up to 9 more without having
to change the list reference.

I hope this helps?


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=487220

Thank you that worked. The only thing is, when I open my drop down list its
displayed empty and I have to scroll up to see my list.
I have also seen a validation box besides the list to update the list, do
you know how to add this box?
Thank you for your help.

"DCSwearingen" wrote:


I am relatively new to this myself.

From what I have read, the list must be in the same worksheet. I
usually put my lists in row one as a horizontal list. Since a
worksheet can have 256 columns, this gives room for a fairly large
list, or several smaller lists. I have used as many as three rows for
my lists. I then hide that row or those rows.

For instance I will use the list $A$1:$Z$1 even though I myght only
have 15 items in the list. Then I can add up to 9 more without having
to change the list reference.

I hope this helps?


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=487220

Debra Dalgleish has lots of info about data|validation at:
http://www.contextures.com/xlDataVal01.html

(Including how to put the list on a different worksheet.)

ED wrote:

How do I add to my drop down list? And how to I create a box to update my
drop down lists<

--

Dave Peterson