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

How to show/hide excel worksheet using UserForm
Transfer data from one excel worksheet to another automatically - Guide
Split excel worksheets to individual files - Guide
How to automatically update one excel worksheet from another sheet ✓ - Forum - Excel
How to automatically update one excel worksheet from another sheet vba ✓ - Forum - Excel
Automatically transfer data from one sheet to another ✓ - Forum - Excel

1 reply

Answer 1 / 1

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.

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

Subscribe To Our Newsletter!