View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tjh tjh is offline
external usenet poster
 
Posts: 96
Default Listbox - Store values

Hello,

I would like to have the values which the user selects from a listbox stored
to memory while the macro is running. Essentially, I want the user to make a
selection from the list. Once they make their selection, use a radial button
to decide if they need to make another selection from the list. If they
choose yes, then the listbox will reappear, allowing them to make their next
selections. Each time I would like their selections to be stored to memory as
a different variable, so that the code can later reference each of their
selections. This seems like it is somewhat redundant and unnecessary, since
they can choose multiple selections at one time. However, each time the
listbox appears the user will be making multiple selections and grouping
them. That is why the box would need to reappear again (for the next group).
The only other way I can think of doing this would be to place a textbox in
the listbox allowing them to group their selections. I do not know how to do
this either, but it would be more efficient.

Any Suggestions

Thank you