Thread
:
Like operator
View Single Post
#
4
Posted to microsoft.public.excel.programming
Ardus Petus
external usenet poster
Posts: 718
Like operator
I have home-made XLA that should help:
http://cjoint.com/?fwqZQdNgus
It is not protected: you can view & edit the code and the userform
To have tabs alpha ordered, right click on arrows left of tabs list, and
select "Sort tabs"
To select a sheet:
Right-click on a cell and select "Select sheet"
You can type the beginning of the name: it will select corresponding entry
of the list.
To validate: press Enter or double-click on a name
To cancel: press Escape
HTH
--
AP
"marianne" a écrit dans le message de
news:
...
I am trying to write vba code so a user can enter a worksheet name using an
inputbox. The worksheets are named by the client name. e.g. "Smith, Adam"
and
I would like the user to be able to put in the name "Smith" and have the
correct worksheet selected, or a range of worksheets if there are more
than 1
"Smith". How can I write this. The code I have written so far is:
Private Sub Workbook_Open()
On Error GoTo ErrorHandler
Dim stclname As String
Dim stermes As String
Enterclname:
stclname = InputBox("Enter the Client Name")
Worksheets(stclname).Activate
Exit_Workbook_Open:
Exit Sub
ErrorHandler:
stermes = MsgBox("Check the spelling")
Resume Enterclname
End Sub
Thanks in advance
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus