Hello, I want a control box that gives me a list of sheetsin my workbook. I
also want a button thats next to the controm box that says FIND and when
pressed it brings up the sheet that was selected from the control box. Also
is there a way it can always go back to the first sheet that has this control
box and button? This way its always like my cover sheet. Can someone help?

You can do better without VBA:

1. In an un-used column, create a set of hyperlinks to all your various sheets
2. in A1 put a simple data validation drop-down
3. In A2 put =HYPERLINK(A1) (this is click-able)

The advantage here is that you can always get back just by using the Back
button!
--
Gary's Student
gsnu200702


"oxicottin" wrote:

Hello, I want a control box that gives me a list of sheetsin my workbook. I
also want a button thats next to the controm box that says FIND and when
pressed it brings up the sheet that was selected from the control box. Also
is there a way it can always go back to the first sheet that has this control
box and button? This way its always like my cover sheet. Can someone help?

Gary thanks for the reply but im new to all of this so could you explain in
more detail? Thanks!!!

"Gary''s Student" wrote:

You can do better without VBA:

1. In an un-used column, create a set of hyperlinks to all your various sheets
2. in A1 put a simple data validation drop-down
3. In A2 put =HYPERLINK(A1) (this is click-able)

The advantage here is that you can always get back just by using the Back
button!
--
Gary's Student
gsnu200702


"oxicottin" wrote:

Hello, I want a control box that gives me a list of sheetsin my workbook. I
also want a button thats next to the controm box that says FIND and when
pressed it brings up the sheet that was selected from the control box. Also
is there a way it can always go back to the first sheet that has this control
box and button? This way its always like my cover sheet. Can someone help?

Su

Step #1 Get the Back Button
View Toolbars Web

Step #2 make the table of links
In Z1 thru Z10 put:
[Book1]Sheet1!A1
[Book1]Sheet2!A1
[Book1]Sheet3!A1
[Book1]Sheet4!A1
[Book1]Sheet5!A1
[Book1]Sheet6!A1
[Book1]Sheet7!A1
[Book1]Sheet8!A1
[Book1]Sheet9!A1
[Book1]Sheet10!A1
These are just text strings


Step 3 make the validation pull-down
Click on A1
Pull-down:
Data Validation€¦ Allow List Source is
=$Z$1:$Z$10


Step 4 create a click-able version of A1
In A2 enter:
=HYPERLINK(A1)


Note that you are not limited to just A1 on the destination sheets. Make
the cell whatever you want. The Back button is always your way of returning.

I encourage you to play around with this a little

--
Gary's Student
gsnu200702


"oxicottin" wrote:

Gary thanks for the reply but im new to all of this so could you explain in
more detail? Thanks!!!

"Gary''s Student" wrote:

You can do better without VBA:

1. In an un-used column, create a set of hyperlinks to all your various sheets
2. in A1 put a simple data validation drop-down
3. In A2 put =HYPERLINK(A1) (this is click-able)

The advantage here is that you can always get back just by using the Back
button!
--
Gary's Student
gsnu200702


"oxicottin" wrote:

Hello, I want a control box that gives me a list of sheetsin my workbook. I
also want a button thats next to the controm box that says FIND and when
pressed it brings up the sheet that was selected from the control box. Also
is there a way it can always go back to the first sheet that has this control
box and button? This way its always like my cover sheet. Can someone help?

Not the same thing...

But if you rightclick on the VCR (DVD???) like controls to the left of the
worksheet tabs, you'll see a list of worksheets that you can choose.

Debra Dalgleish has an addin that you may want to try:
http://contextures.com/xlToolbar01.html

oxicottin wrote:

Hello, I want a control box that gives me a list of sheetsin my workbook. I
also want a button thats next to the controm box that says FIND and when
pressed it brings up the sheet that was selected from the control box. Also
is there a way it can always go back to the first sheet that has this control
box and button? This way its always like my cover sheet. Can someone help?

--

Dave Peterson