Forum Discussion
Add a cell with text according to a list of choices - VBA
Hi everyone, don't know where to start this kind of macro. But I have 3 lists that if I selected one from the lists, it will then populate certain text in a cell. Say for example on the attached file.
Okay, please find the attached and once you select any cell in the range B1:D1, the corresponding ingredients list will be populated.
7 Replies
It wouldn't have to involve macros or VBA routines. This can be done with what I've called a cascading set of Data Validation steps. I've attached an example that works with first and last names, but the same logic could apply to sets of ingredients based on a first selection of the dish to prepare.
Note: these functions do require the most recent version of Excel. Here's a YouTube video that explains the Dynamic Array functions. https://www.youtube.com/watch?v=9I9DtFOVPIg
- Is it a complete file? Where are the ingredients lists which you want to populate based on the selection?
Subodh_Tiwari_sktneer please find the attached file. Thanks in advance 🙂
Please find a simple setup with three named ranges called "Apple_Pie", "Custard_Pie" and "All_Pies" on the List Sheet then you may select an item from the dropdown in B1 to populate the list of corresponding ingredients. See if this is what you were trying to achieve.
The Code is placed on Sheet1 Module for Sheet_Change Event.
