Switching to a specific worksheet

[JR]

I'm new to VBA and have a sub that creates a new worksheet with the
name specified in a input box. I would like to switch back to my
original worksheet after the creating the new one and I'm lost. I
would also like to switch to any worksheet just by entering the WS
name in an input box. Appreciate any help.

Thanks

 

[Wigi]

Something like:


Dim sSheetNameOriginal As String

sSheetNameOriginal = ActiveSheet.Name

'your code

Sheets(sSheetNameOriginal).Select 'to go back