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?



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

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