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
