How to show/hide excel worksheet using UserForm

Closed
akumarsahu
Posts
2
Registration date
Sunday June 8, 2014
Status
Member
Last seen
June 8, 2014
- Jun 8, 2014 at 06:05 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Jun 12, 2014 at 11:21 AM
Hello,

I have prepared one user form and given option button & submit button.

I have 4 worksheet. My queries is....

1. If I select Option 1 and click submit button then my Sheet 1 should visible likewise If I click on Option button 2 and then click submit button then my sheet no 2 should visible and sheet one will hide.

Please help me to proceed with this formulae

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jun 11, 2014 at 07:17 PM
on click of button you can trigger code to hide sheet and display sheet.
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Jun 12, 2014 at 11:21 AM
Hoeray Riz is back! I thought we lost you!

Hopefully you are doing great.

Good to see you again.

Trowa
0