I'm not sure I understand your question... you can do what I described using
an ActiveX ListBox from the Control Box toolbar (not a non-ActiveX ListBox
from the Forms toolbar) on a worksheet directly or the ListBox (also an
ActiveX one) on a UserForm. You can apply VB code to either using Assign
Macro for the ListBox placed directly on the worksheet or the UserForm's
code window (again, depending on where the ListBox is located).

Rick


"Jolly" wrote in message
...
Rick, Is this done in VB or can I do it in excel?

"Rick Rothstein (MVP - VB)" wrote:

You don't need separate CheckBox'es to do what you want... just change
the
ListBox's ListStyle property to 1-fmListStyleOption and, when a
MultiSelect
mode is selected, check boxes will be added in front of each item in the
ListBox (if you don't select one of the MultiSelect modes, then option
buttons are placed in front of the items instead).

Rick


"Jolly" wrote in message
...
I have now entered a check box against each item to let the user choose
any
item from list. This will allow me to take action on what the user has
chosen
and thus take action accordingly. Is there an easy way to align the
check
boxes with the list? Your help much appreciated.
Thanks

"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?