Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am creating an iPad compatible application with 5 sheets displaying graphs (SH01, SH02, SH03, SH04, SH05) then a 6th sheet (SH06) is a "Filter" sheet in which the user can select from multiple list boxes. What I am having difficulty with is, let's say the user is on SH04, then selects an action button that takes them to SH06 to choose their filters. I want the user to select another action button that would take them back to SH04. Obviously if the user is on SH03, then goes to the Filter sheet, I want them to return to SH03.
How can this be done?
Hi.
You can use a variable to store the previous sheet name.