Hi

Your answer seems the best way to do it but ive not used if statements in
Excel before so require abit of guidance.

So how and where would I place the code.

Right now I have a excel file called -Document process
within the file I have two worksheets - 1.document , 2. Data.

I have placed in 2.data a column (A) called animals and populated that with
my animal options for my list.

In 1.Document I place a column (B) called animal choices.

How would I use the if statement to populate in 1.document cell (B2) with
multiple choices made.

Thanks in advance


"Daniel.C" wrote:

Hello.
Use the Multiselect property of the listbox.
To retrieve the selected items, use (case of a worksheet listbox :

With Sheet1.ListBox1
For i = 0 To .ListCount - 1
If .Selected(i) Then
'code
End If
Next i
End With

HTH
Daniel

Hello all,

I'm trying to see if it's possible to create a list box where I can select
multiple values. For example, if a create a list box with the values, "ant",
"dog", and "cat". Is it possible for me to give the user the option to
choose, "ant" and "cat"?

Thanks in advance.