Linking combo boxes can be done in a number of ways and is very useful in reporting. This recorded webinar illustrates how to synchronise two or more combo boxes so that when you select an item in the first combo box only the items which relate to the first combo box are shown in the second combo box. If you have one department and sub groups under this group selecting the first group will only allow the sub group which is related to show.
Key topics:
- Create a series of named ranges and the INDIRECT formula to act as the source data for the combo boxes
- Create a series of combo boxes which are linked to the named ranges and are able to communicate to one
- An additional technique will be demonstrated which will show how to create 4-5-6 combo boxes all linked together. This technique is unique and requires very little maintenance
Learning objectives
- Create a series of named ranges in Excel which will be drawn upon inside the combo boxes
- Generate the formulations which will make the model spin based on the combo box selection
- Make 5 combo boxes, two static and 3 which will be dependent (3 level hierarchy combo boxes)
- Generate some summary formulation which allows us to show single selection or the sum of the whole
- Show the same process with a VBA model which manages the combo boxes through a dedicated list
- Work through the detailed tasks accompanying the webinar to test your knowledgeÂ
Audience
Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles in job functions such as external reporting, financial control and management accounting.
