How to navigate hidden worksheets with Activex combo-box using VBA in Excel | Learn in 5 Minutes

Опубликовано: 06 Октябрь 2024
на канале: Learn In 5 Minutes

2,702

In this video you will learn:

How to create an ActiveX combo-box, add sheet names as values in it.
How to navigate to a sheet by selecting the sheet name from ActiveX combo-box
How to make all sheets hidden and unhide when the sheet is selected from ActiveX Combo-Box and again hide the sheet when navigated to ActiveX Combo-box sheet.

Practice File: https://bit.ly/3BjHrN4

Timestamps:
00:00 Intro
00:17 Creating a ActiveX Combo-box on selecting the sheet
01:18 Adding sheet names to ActiveX Combo-box
05:41 Navigating sheets with ActiveX Combo-box
07:22 Giving placeholder to ActiveX Combo-box
08:30 Hide and unhide sheets with ActiveX Combo-box
09:38 Adding sheet names to ActiveX Combo-box on workbook open
11:03 Closure