be able to access worksheet while form is running
Private Sub Userform_Initialize()
Dim sh as Worksheet
for each sh in worksheets
combobox1.AddItem sh.Name
Next
End Sub
Private Sub Combobox1_Click()
if combobox1.ListIndex < -1 then _
worksheets(combobox1.Value).Activate
End sub
--
Regards,
Tom Ogilvy
"Monte0682" wrote:
How is this possible to do? I want to run a form and be able to select
what worksheet I want...
|