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