av8tordude
04-17-2011, 08:42 PM
I have 4 frames on a userform. I have a button on sheet 1, 2, 3, 4. How can I call a userform and make visible only the frame that corresponds to the sheet the button was used.
example...
If I'm on sheet1 and I click the button to display the userform, only frame1 should be visible. All other frames (2,3,&4) should be invisible.
If I'm on sheet2 and I click the button to display the userform, only frame2 should be visible. All other frames (1,3,&4) should be invisible.
etc.
Thanks for you help
example...
If I'm on sheet1 and I click the button to display the userform, only frame1 should be visible. All other frames (2,3,&4) should be invisible.
If I'm on sheet2 and I click the button to display the userform, only frame2 should be visible. All other frames (1,3,&4) should be invisible.
etc.
Thanks for you help