Previous Topic Next Topic

How to show/hide excel worksheet using UserForm

Closed
akumarsahu Posts 2 Registration date Sunday 8 June 2014 Status Member Last seen 8 June 2014 - 8 Jun 2014 à 06:05
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 12 Jun 2014 à 11:21
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
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
11 Jun 2014 à 19:17
on click of button you can trigger code to hide sheet and display sheet.
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
12 Jun 2014 à 11:21
Hoeray Riz is back! I thought we lost you!

Hopefully you are doing great.

Good to see you again.

Trowa