Gary Keramidas wrote:
you may be able to use a combobox.

create a new test userform and just add 1 combobox to it, then paste this
code and see if it will give you some ideas.

Private Sub ComboBox1_Change()
Worksheets(Me.ComboBox1.Value).Activate
End Sub

Private Sub UserForm_Activate()
Dim i As Long
For i = 1 To Worksheets.Count
Me.ComboBox1.AddItem Worksheets(i).Name
Next
End Sub



I've never used a userform before and have no experience with this area
of macros. HOWEVER, this is very interesting.

It took me a few sites, and a few moments to get a rough handle on
creating and using forms altogether before I was able to get your
example to work.

After naming the form to frmDropIt, I was able drop in the private
codes, and then create the combo.

Next, I was finally able to create the module code.

Sub test()
frmDropIt.Show
End Sub

I saw from a site that the code may need the .Show at the end of the
form name. I assumed this just shows the form and then the form takes it
from there. I think that I can expand on this and use it for what I
need. I see that I'll need to break out my excel VBA reference books to
read up. I never thought that I would ever need a form, but I'm converted.


Thanks.