View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kees Korver[_4_] Kees Korver[_4_] is offline
external usenet poster
 
Posts: 1
Default Simple VBA question (?)


Hi all, probably quite simple question, but I can't find the answer
......

In my Excel-application 4 pages (worksheets) exist: for example A,B,C
and D
Button on page A moves the user to page D
A similar button on page B navigates user also to page D

Now I wish to implement one button on page D "back" it should move
the user back to the originating page, i.e. where he began his journey.
In some cases he should go back to A, but sometimes to B.
How should Excel remember the starting page??

I tried Dim blabla as Name; blabla = Active.Worksheet.Name then
navigate to page D, then return to blabla. But the only thing happening
is lots of error messages.
I presume the solution could be simple? I am very grateful with an
answer!
Thanks,
Kees


--
Kees Korver
------------------------------------------------------------------------
Kees Korver's Profile: http://www.excelforum.com/member.php...o&userid=21562
View this thread: http://www.excelforum.com/showthread...hreadid=558249