My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

How to create combo box to pull data from hidden tabs in workbook|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / How to create combo box to pull data from hidden tabs in workbook|General Excel Questions & Answers|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
How to create combo box to pull data from hidden tabs in workbook
Avatar
Stee Wan

New Member
Members
Level 0
Forum Posts: 2
Member Since:
August 10, 2018
sp_UserOfflineSmall Offline
1
August 10, 2018 - 9:05 pm
sp_Permalink sp_Print

Hello All,

 

Help please.

I have so many tabs with data in a workbook.

I want to be able to click on a list (combo box) to pull all the data relating to the tab whilst the tabs are hidden.

This means the workbook only displays a front and provides the information required when the droplist is activated.

How do I go about achieving that please?

Grateful for any help.

 

Many thanks in advance. PS, apologies if the topic has already been covered.

 

Best regards,
Stee Wan

Avatar
SunnyKow
Puchong, Malaysia

VIP
Members


Trusted Members
Level 8
Forum Posts: 1432
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
2
August 11, 2018 - 1:27 am
sp_Permalink sp_Print

Hi Stee

I don't see any reason why the list or combo box is unable to pull the data from the hidden tabs.

You did not specify whether the list/combo box are Form or ActiveX Controls.

I am only assuming it is a Form Control but it doesn't matter as both will able to pull the data.

Maybe you could attach a sample of your file for us to take a look.

Sunny

Avatar
Stee Wan

New Member
Members
Level 0
Forum Posts: 2
Member Since:
August 10, 2018
sp_UserOfflineSmall Offline
3
August 11, 2018 - 2:24 am
sp_Permalink sp_Print

Thanks Sunny for the prompt response and desire to assist.

Said data is highly sensitive. I will look for some sample data online and use that to demonstrate what I mean.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Louis Muti, Misael Gutierrez Sr.
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Cathi Giard
Sarah Young
Henry Delgado
Alita Nieuwoudt
KL KOH
Joao Marques
Regi Hampton
Taffie Elliott
Paramita Chakraborty
David du Toit
Forum Stats:
Groups: 3
Forums: 24
Topics: 6358
Posts: 27805

 

Member Stats:
Guest Posters: 49
Members: 32335
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen