On Nov 21, 11:26*pm, "DVAL" wrote:
Hi

How to make Drop down list (Form Control - Combo box)
with names of worksheets and then when I select a list
value that I created I want to go to another worksheet.

SO, I want to pick one name from Drop down list and that worksheet then
opens!
for each WSHT in MyDOC.Worksheets
DropDown1.additem WSHT.Name
next WSHT