G
grizzly6969
How do you create a drop down form in an excel worksheet
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John
Hi
One easy way is : Data>Validation, if you already have a list, click in one cell
and goto
Data>Validation select List, highlight your list and you got a dropdown list '
HTH
John
One easy way is : Data>Validation, if you already have a list, click in one cell
and goto
Data>Validation select List, highlight your list and you got a dropdown list '
HTH
John
C
Chip Pearson
Put the items that should appear in the list in some range on the
worksheet, say A1:A10. Then select the cell where you want the drop
down to appear. Go to the Data menu and choose Validation. There,
select "List" in the Allow list and enter =A1:A10 as the source.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
worksheet, say A1:A10. Then select the cell where you want the drop
down to appear. Go to the Data menu and choose Validation. There,
select "List" in the Allow list and enter =A1:A10 as the source.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
G
grizzly6969
Thanks John
--
grizz
--
grizz
John said:Hi
One easy way is : Data>Validation, if you already have a list, click in one cell
and goto
Data>Validation select List, highlight your list and you got a dropdown list '
HTH
John
L
L. Howard Kittle
You have three solutions, but you can also just put your list in the Data
Val wizard Source box, red,blue,green etc.(separated with a coma) With
large lists selection of the list range is pretty easy and painless.
You may run into a case where your huge list is on another worksheet. If
this is the case, go to that sheet select the list and in the name box name
it something appropriate to the list, MyList, AllGoodFoods, StateCapitals or
such. Now in the Source box type in =MyList, or whichever list you named,
hit OK.
HTH
Regards,
Howard
Val wizard Source box, red,blue,green etc.(separated with a coma) With
large lists selection of the list range is pretty easy and painless.
You may run into a case where your huge list is on another worksheet. If
this is the case, go to that sheet select the list and in the name box name
it something appropriate to the list, MyList, AllGoodFoods, StateCapitals or
such. Now in the Source box type in =MyList, or whichever list you named,
hit OK.
HTH
Regards,
Howard
C
Chris Bode via OfficeKB.com
Well, if you want a drop down list from VBA then follow following steps
1.Right click on toolbar>click control box
2.From the control box that appears on your sheet, select a combo box and
draw it to your sheet
3.It will add a drop down box to you sheet
to populate the drop down list use following code
ComboBox1.AddItem("<item>")
Again there is another way to add a drop down list,
1.In sheet2 column A enter some data
2.Select the data you entered and name it as mydata by typing mydata in the
box to the left top
3.Select cell A1 in sheet1,
4.Select data>validation from menubar
5.From the setting tab,select list from allow and enter following in source
box
=mydata
6.Click OK
Now, you are done!
Have a nice time
Chris
1.Right click on toolbar>click control box
2.From the control box that appears on your sheet, select a combo box and
draw it to your sheet
3.It will add a drop down box to you sheet
to populate the drop down list use following code
ComboBox1.AddItem("<item>")
Again there is another way to add a drop down list,
1.In sheet2 column A enter some data
2.Select the data you entered and name it as mydata by typing mydata in the
box to the left top
3.Select cell A1 in sheet1,
4.Select data>validation from menubar
5.From the setting tab,select list from allow and enter following in source
box
=mydata
6.Click OK
Now, you are done!
Have a nice time
Chris