Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Periodically Store/Save Excel DDE Values | Excel Discussion (Misc queries) | |||
Need to store changing values from one cell | Excel Discussion (Misc queries) | |||
Store values of a dynamically changing cell | Excel Worksheet Functions | |||
ReDim to store values so they are not used again | Excel Programming | |||
update and store new high values | Excel Programming |