I am at design stage of my spreadsheet model.
I plan to have a Listbox in which user should be able to make multiple selections. Based on user's multiple selection, I want it to return their respective position/values in the list). I plan to use these position/values (in conjunction with Index function) to define criteria for Dsum function, which in turn will be used [on my raw data] to return basic input values for my spreadsheet model.
My questions are
-Which List-Box should I use- Form or Control Tool-bar List box? Does one has an advantage over other in terms of manipulation via code.
-If someone could share the code which can return selection's respective position/values in the list.
I hope I am clear. I apologize for any confusion. I tried searching for answers but couldnot land on something which answer my question.
Thanks for your help and any insight will be appreciated.