Hello all,
I have been diving into learning VBA recently and have started creating a user form that serves to inspect multiple items in a kit. Basically, each item can pass, be quarantined, or fail, and I would like buttons for each of these options for each item on a list that is populated when the user selects which kit in the top ComboBox. The closest solution to creating buttons dynamically I can come up with is seen in the screenshot below, where another 3 listboxes are used for pass, quarantine and fail, respectively, populated alongside the list that displays information about each item. Unfortunately, the use of the liststyle property to create these options changes the row height so the rows don't line up, and changing the liststyle of the first listbox would create a tickbox on the left, which I don't want. Is there anyway to adjust rowheight within the listbox to achieve this, without changing font size?
Alternatively, is there an altogether different solution that may produce the same results? I am fairly new to VBA so more than open to suggestions.
Thanks,
Phil
I have been diving into learning VBA recently and have started creating a user form that serves to inspect multiple items in a kit. Basically, each item can pass, be quarantined, or fail, and I would like buttons for each of these options for each item on a list that is populated when the user selects which kit in the top ComboBox. The closest solution to creating buttons dynamically I can come up with is seen in the screenshot below, where another 3 listboxes are used for pass, quarantine and fail, respectively, populated alongside the list that displays information about each item. Unfortunately, the use of the liststyle property to create these options changes the row height so the rows don't line up, and changing the liststyle of the first listbox would create a tickbox on the left, which I don't want. Is there anyway to adjust rowheight within the listbox to achieve this, without changing font size?
Alternatively, is there an altogether different solution that may produce the same results? I am fairly new to VBA so more than open to suggestions.
Thanks,
Phil
