Passing variables

**lordfa9** · 05-15-2007, 05:53 AM

Ok lets say i have these pages in my workbook in this hierachical order:

A -> either B or C -> D

Every page starting from B onwards will have a back button to return to the previous page, so B/C will return to A.

The question is if i'm at D, i expect the back button to take me to either B or C (depends on where i came from). Is there any way to do this?

Background info:
I have some knowledge in ASP so i understand querystrings. Is there any way i can send this data from B/C to D using one? If so, what language do i use?

**lordfa9** · 05-16-2007, 05:27 AM

could someone help me with this please?

**dominicb** · 05-16-2007, 05:47 AM

Good morning lordfa9

Try putting this module into the ThisWorkbook module :

Please Login or Register  to view this content.

and put this code in a normal module. This is the code that your back button needs to link into. The above module just keeps a constant track of the last sheet.

Please Login or Register  to view this content.

This will only give you one level of going back - there will be no history.

HTH

DominicB

**lordfa9** · 05-16-2007, 09:07 PM

now i'm really confused...

whats a ThisWorkbook Module?

**dominicb** · 05-17-2007, 05:21 AM

Good morning lordfa9

From Excel press Alt + F11 to go to the VBE.
Find your project on the left hand side (eg, VBAProject (Book1.xls))
Make sure it's expanded
Double click on the ThisWorkbook text
A new window should open on the right with two dropdowns at the top - General and Declarations. This is the ThisWorkbook module. Paste the code into here.

HTH

DominicB

**lordfa9** · 05-17-2007, 05:34 AM

ok so the 1st part is a global (sheet-wide) macro

how do i incoporate the 2nd part with a hyperlink?

apologies if i dont understand, i thought it would be something like a querystring

**dominicb** · 05-17-2007, 06:33 AM

Hi lordfa9

You paste the second part into a regular module (from the VBE, Insert >Module). Then on every sheet, draw a button using the Forms toolbar, and assign each one to the macro I've called "test". Change the text on it to "Back" and each time you click on it it will take you to the previous sheet.

See my example below.

HTH

DominicB

Passing variables

LinkBack

Thread Tools

Rate This Thread

Display

Passing variables

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions