MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro to activate specific sheet through user input?


Posted by Garland on December 25, 2000 10:58 PM

Can anyone suggest a macro to take user input, from say
an inputbox, locate a sheet from the data entered,
then activate that sheet?

TIA

Garland


Posted by cpod on December 26, 2000 2:01 PM


Dim strWS As String
strWS = InputBox("Enter worksheet name")
Worksheets(strWS).Activate