sheet selection from an input box - Thank you
And you also
--
Gary''s Student - gsnu200811
"Eduardo" wrote:
Thank you again and have a great weekend
"Gary''s Student" wrote:
It just insures that a String gets returned and not a number.
By the way, I don't know how to do the password thing.
--
Gary''s Student - gsnu200811
"Eduardo" wrote:
Gary just a question what Type:=2 means
"Gary''s Student" wrote:
Sub sheet_picker()
Dim s As String
s = Application.InputBox(prompt:="enter sheetname:", Type:=2)
Sheets(s).Activate
End Sub
--
Gary''s Student - gsnu200811
|