Dear All,
I have searched for a resolution of this query a lot today and didnt find an answer; hence posting it here.
Theres a list of 5 items in my Sheet1. I want to create a listbox out of those items for selection. And then there are some formulae below that will work with reference to those selected items (vlookup, sumif etc).
I'd use data validation and prepare my data but with only one selection at a time. I want to have multiple selections possible and hence; listbox. I am new to VBA and do not know much about writing the codes.
If I can get the selected items in a listbox as text in specified cells; the rest of the formulae can work. My question; how can I get the selected items in a listbox as text in specified cells? (assume cells A1 to A5) What should be the code?
Any help is highly appreciated.
Regards,
Apurva Oka.
I have searched for a resolution of this query a lot today and didnt find an answer; hence posting it here.
Theres a list of 5 items in my Sheet1. I want to create a listbox out of those items for selection. And then there are some formulae below that will work with reference to those selected items (vlookup, sumif etc).
I'd use data validation and prepare my data but with only one selection at a time. I want to have multiple selections possible and hence; listbox. I am new to VBA and do not know much about writing the codes.
If I can get the selected items in a listbox as text in specified cells; the rest of the formulae can work. My question; how can I get the selected items in a listbox as text in specified cells? (assume cells A1 to A5) What should be the code?
Any help is highly appreciated.
Regards,
Apurva Oka.
