VBA: Need Help Activating Sheets from Listbox(Sheet Names)

[BIGTONE559]

Greetings,

I have a form that i've created that populates with the sheet names once the form is shown. I need help with once a sheet name is selected. I would like to activate the sheet once ok is pressed. not sure how to refer to the names in vBA

Thanks

 

[VoG]

Try like this

Private Sub CommandButton1_Click()
Sheets(ListBox1.Value).Select
Unload Me
End Sub

 

[BIGTONE559]

Thanks as usual vog. Gave me direction and i was able to accomplish what i wanted.!

Cheers