Forum Discussion
Solved
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.
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.
Hi, appreciate the time you are taking out on this. Is there a way to make it like a clickable cell rather than a drop-down list?
