VBA roadmap of which sheet I came from?

[Excellentt]

As I use a macro or VBA to accomplish a procedure, I need to be able to “Capture” which sheet I came from in order to return to that sheet and grab more info.
How do I track this info? I essentially need the Sheet number “Dropped off” someplace so I can use it later.
I plan on using

Please Login or Register  to view this content.

as the way to get back to the sheet from whence I came, but how do I capture the sheet number of where I came from?

Thanks!

[xladept]

Hi Excellentt,

Please Login or Register  to view this content.

Then jump out and to return:

Please Login or Register  to view this content.

[Excellentt]

xladept,
Thank you, that’s awesome.

Is there a way to do this numerically? Meaning, I have 31 sheets that correspond to days. If I leave from "3" (day 3) to go to a form, could I tell VBA to go back to “3”?

[xladept]

Hi Excellentt,

Please Login or Register  to view this content.

[Excellentt]

Figures that it's that easy!

Thanks again for the help!!

---------- Post added at 04:48 PM ---------- Previous post was at 04:46 PM ----------

Sorry.....

How do I know what the sheet number is? Is that the same as Codename?

[xladept]

Not the same as Codename - but it's the name on the tab!

Here's the same code as first posted with a twist:

Please Login or Register  to view this content.