didnt spot that, if you change above sub to this you can activate any worksheet from the listbox listing![]()
Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) WorkSheets(ListBox1.Value).Activate End Sub
didnt spot that, if you change above sub to this you can activate any worksheet from the listbox listing![]()
Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) WorkSheets(ListBox1.Value).Activate End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks