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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 12, 2014 at 11:21 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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
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
Related:
- How to show/hide excel worksheet using UserForm
- How to hide app store on ipad - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to see hide story on instagram - Guide
- How to hide comments on steam - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 11, 2014 at 07:17 PM
Jun 11, 2014 at 07:17 PM
on click of button you can trigger code to hide sheet and display sheet.
Jun 12, 2014 at 11:21 AM
Hopefully you are doing great.
Good to see you again.
Trowa