
New Member

August 10, 2018

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

VIP

Trusted Members

June 25, 2016

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
1 Guest(s)
