LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Periodically Store/Save Excel DDE Values ** Excel Discussion (Misc queries) 1 August 10th 07 09:17 PM
Need to store changing values from one cell Emmie Excel Discussion (Misc queries) 5 September 17th 06 08:10 PM
Store values of a dynamically changing cell Yogesh Excel Worksheet Functions 0 August 4th 05 06:40 PM
ReDim to store values so they are not used again hotherps[_16_] Excel Programming 0 February 18th 04 06:34 PM
update and store new high values jack[_5_] Excel Programming 0 July 10th 03 01:22 AM


All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"