How do you create a drop down form in an excel worksheet
--
grizz

Hi
One easy way is : DataValidation, if you already have a list, click in one cell
and goto
DataValidation select List, highlight your list and you got a dropdown list '
HTH
John

"grizzly6969" wrote in message
...
How do you create a drop down form in an excel worksheet
--
grizz

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)

On Fri, 13 Feb 2009 13:38:05 -0800, grizzly6969
wrote:

How do you create a drop down form in an excel worksheet

Thanks John
--
grizz


"John" wrote:

Hi
One easy way is : DataValidation, if you already have a list, click in one cell
and goto
DataValidation select List, highlight your list and you got a dropdown list '
HTH
John

"grizzly6969" wrote in message
...
How do you create a drop down form in an excel worksheet
--
grizz

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

"grizzly6969" wrote in message
...
How do you create a drop down form in an excel worksheet
--
grizz

Well, if you want a drop down list from VBA then follow following steps
1.Right click on toolbarclick 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 datavalidation 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
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1