Hi
I don't understand what did you mean with that?
;(

"NOPIK" wrote in message
...
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