Forum Discussion
Add a cell with text according to a list of choices - VBA
Okay, please find the attached and once you select any cell in the range B1:D1, the corresponding ingredients list will be populated.
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?
Okay, please find the attached and once you select any cell in the range B1:D1, the corresponding ingredients list will be populated.