Userform listbox with checkboxes

This might not be possible, but I figure there's no harm in asking. I would like to have listbox where the user can select multiple items; this is easy. What I suspect is not so easy is for it to also have "special" checkboxes, and by this I do not mean selecting fmListStyleOption from the ListStyle property. What I need is for the user to be able to select items but, depending on whether the checkbox next to the selected item is checked or not, the macro will do some extra "stuff" (extra formatting or a different calculation, etc, etc). In other words, I would like the user to be able to check/uncheck the checkboxes independently from the item selection.

As a workaround, I've programmed the Userform_Activate event to dynamically add individual checkboxes next to the listbox based on the number of listbox items, but the spacing is often not quite right (especially when run on other people's computers) so a lot of the time the listbox items don't line up with the checkboxes correctly making it a pain to ensure that the right checkbox was checked.

Thanks!
Alex

Thanks AlphaFrog! That's a great idea! Actually, I'll modify it to take advantage of the listbox's double-click event and skip the option buttons since I only need a single yes/no option for now. I'll keep it in mind, though, in case the need for more options ever comes up.

Cheers,
Alex