Checkbox in Listbox

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • proulxfr
    New Member
    • Mar 2012
    • 1

    Checkbox in Listbox

    In Excel, using VBA I created a userform that presents a dynamic listbox. This listbox is build with information included in a specific worksheet. This information is not predefined, it is given by the user varying naming and number of items defined.

    By selecting one ore more items from listbox you are able to add specific row in the designed items group. This works fine but using listbox and multiselect. Now I would like to preceed the items in the listbox with a checbox. Rather then selecting items, user may select the assigned checkbox instead.

    Thank you for your assistance.
  • Guido Geurs
    Recognized Expert Contributor
    • Oct 2009
    • 767

    #2
    Do you want something like this:
    In the listbox are number from the sheet and with a checkbox representing a "1" you want to select in the listbox all the numbers beginning with "1".
    with a checkbox "3" you will also select all the numbers in the list beginning with "3".
    And so on...

    If this is not the right description of your problem, is it possible to attach in Bytes a demo of your sheet and VBA so we can understand your problem?
    If the data is confidential, replace it with fictive data.
    Also if the sheet has to much data, delete most part.

    Comment

    Working...