I said "if" in my statement where I referred to Design Mode. You would only
have to worry about Design Mode IF you had the ListBox directly on the
worksheet (this is not something you have to concern yourself with if the
ListBox is on a UserForm). Design Mode can be enabled/disabled from the
Visual Basic toolbar.

Rick


"Jolly" wrote in message
...
Sorry I don't follow. I do not have design mode option in excel.

Rita

"Rick Rothstein (MVP - VB)" wrote:

Right-click the ListBox (you will need to be in Design Mode if the
ListBox
is on the worksheet), select Properties from the popup list and change
the
MultiSelect property to one of the two multi-select settings.

Rick


"Jolly" wrote in message
...
I am trying to create a user friendly input form in Excel. I am using
the
control toolbox for this. I would like the user to choose one or more
items
from a list. The list box or option/ tick buttons allows only one item
to
be
chosen from the list. Is there an option for choosing multiple item?

I would also like to know why and when to use user form in VBE v
control
toolbox options in Excel workbook?