Almost forgot: To read the value of the selected item stored in the list
(after determining that ListBox1.Selected(i) is true), use ListBox1.List(i)
--
- K Dales


"excel_slave - ExcelForums.com" wrote:

Here is what my objective is (trying to do it in VBA/Excel):

Based on a user's selection, a variable number of options show up.
These options are drawn from a biger list comprising hundreds of
options. For example

Selection: A
Options: 1, 7 and 32

Selection: B
Options 7, 96

This part of the code is simple.

Now the user should have the ability to select (checkbox or some other
control) one/all of the options being displayed. Once the user has
made her selection, some operation is performed at the backend only
for the options selected (e.g. timeVerified for the selected option
is updated in another spreadsheet etc)

I am struggling with the functionality to set up a variable number of
checkboxes that show up based on the initial selection by the user.
Additionally, how can the VALUE in of the selected option be passed
(e.g. 7, 96 etc) so that the underlying program knows what to
change.

Any help/sample code will be appreciated.