Click on cell (or "button"), takes you to appropriate information
 

I am building a spreadsheet, and I would like to be able to create a cell
that when you click on it, it looks like a "button" and then automatically
takes the user to the approriate information.

For instance, I ask a question: "Did your firm sell any fixed assets this
year? If yes, fill out Schedule R" Then, I place a cell called "Schedule R"
that relates to Schedule R at the end of the question...the user clicks that
"button" and it takes them to Schedule R.

I'm sure this is easy for an advanced user, but I am not that ;)!

Thanks!

Click on cell (or "button"), takes you to appropriate information
 

Maybe you could use a hyperlink instead:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)


Or you could use a macro a real button from the Forms toolbar:

Option Explicit
Sub GoToScheduleR()

application.goto worksheets("Schedule R").Range("a1"), scroll:=true

End sub

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)


ahwelch wrote:

I am building a spreadsheet, and I would like to be able to create a cell
that when you click on it, it looks like a "button" and then automatically
takes the user to the approriate information.

For instance, I ask a question: "Did your firm sell any fixed assets this
year? If yes, fill out Schedule R" Then, I place a cell called "Schedule R"
that relates to Schedule R at the end of the question...the user clicks that
"button" and it takes them to Schedule R.

I'm sure this is easy for an advanced user, but I am not that ;)!

Thanks!

--

Dave Peterson