Links for Sheets

Is it possible to have a link in an excel workbook where there are multiple sheets so that if you quickly need to go to another sheet you would just click on the link and it would take you directly to the sheet i.e. from the sheet where you are currently working?

Ta

I have a workbook with 42 sheets in it.
To navigate quickly from one sheet to another I created a UserForm.
On the UserForm i've created a comboBox1.
The RowSource in the Properties of ComboBox1 is linked to a database name which contains a list of all my worksheet tab names. I created the list using
the 'Insert', 'Name', 'Define' method.

I also have a macro button on the UserForm that has the following code:-

shString = ComboBox1
Sheets(shString).Select
Range("A1").Select

All very simple but affective.
Hope this is of some help.
Pete G

Thanks for the help on this - However, I am not that familiar with compo boxes or the insert name and define option - I see in excel where to access these functions but could do with a bit more help with exactly how to apply and what steps to take.

Cheers

you will need to go into macro and create a new macro (not record). This will load up the VB editor. You can click on the forms toolbox to create a new userform with the drop down box in question.

Ensure the rowsource in the properties of this box is referenced to the workbook contents range (ie. A1 cell contains the first worksheet name, A2 the second, A3 the third...). So for these properties it should read A1:A3

Insert a command button onto the user form and double click. This will bring up:

Private Sub CommandButton1_Click()

End Sub

Now you paste this in between:

shString = ComboBox1
Sheets(shString).Select
Range("A1").Select

Once this is done, whenever you run the macro you just created the dialogue box you just designed based on the contents will appear. To have this load up when the file is opened, just create a macro called Auto_Open and paste this command in the middle of it:

UserForm1.Show


Hope this helps. If not, look at my example for you.

Dan

Have you tried creating a Hyperlink?
Choose where you would like the hyperlink to appear on your sheet
Go to Insert and choose Hyperlink and select "place in this document" and choose from the list.