Hi all,
I'm brand new to VBA, so I'm trying my best but I could definitely use some help on this one. I have a listbox of 5 items with the ability to select multiple items from the listbox. However, I want when you click on an item in the listbox for a textbox to appear relating to that selection.
Example:
Label: What Fruits Do You Like?
Contents of Listbox: Apples, Oranges, Bananas, Strawberries, Razzberries
I want you to be able to select any amount of fruits you want, but if you just click Apples, I want a specific label to come up and say "Why do you like apples?" with a textbox to answer, but if you click both bananas and strawberries, I would like separate labels and textboxes for each fruit to come up.
I know that sounds convoluted, if there's anything I can do to clarify, let me know.
I'm brand new to VBA, so I'm trying my best but I could definitely use some help on this one. I have a listbox of 5 items with the ability to select multiple items from the listbox. However, I want when you click on an item in the listbox for a textbox to appear relating to that selection.
Example:
Label: What Fruits Do You Like?
Contents of Listbox: Apples, Oranges, Bananas, Strawberries, Razzberries
I want you to be able to select any amount of fruits you want, but if you just click Apples, I want a specific label to come up and say "Why do you like apples?" with a textbox to answer, but if you click both bananas and strawberries, I would like separate labels and textboxes for each fruit to come up.
I know that sounds convoluted, if there's anything I can do to clarify, let me know.