BrianExcel
Well-known Member
- Joined
- Apr 21, 2010
- Messages
- 975
On one page of a workbook I have radio buttons for portrait and landscape. Choosing one determines which direction the page is displayed in.
On another page, I offer stapling options such as Upper left, upper right, lower left and lower right. Each one has a corresponding picture.
What I need to do is show the right picture based on the upper left/right or lower left/right buttons chosen, but also FIRST based on the orientation of the page.
So instead of doing two IF statements, I want to include the orientation from the first page when looking at the selection, so basically IF landscape is chosen, display the LANDSCAPE image on the second page when the corner is chosen.
Ideas? Does this make sense?
On another page, I offer stapling options such as Upper left, upper right, lower left and lower right. Each one has a corresponding picture.
What I need to do is show the right picture based on the upper left/right or lower left/right buttons chosen, but also FIRST based on the orientation of the page.
So instead of doing two IF statements, I want to include the orientation from the first page when looking at the selection, so basically IF landscape is chosen, display the LANDSCAPE image on the second page when the corner is chosen.
Ideas? Does this make sense?
