Hi,

I have a multiselect listbox with about 100+ rows, each row can have
one of 4 different application status (ie. 4 types of rows). Ideally
the user should be allowed to select only one type of row. What is
the best way to achieve this?

Is there a way in Excel VBA to selectively disable specific items in a
listbox? Something like greying out the row or removing the option
button for that row will do nicely, i think.

The workaround I use right now is cludgy - I display 2 listboxes - one
for the selectable entries and the other for the all the other type of
rows... Needless to say I am totally unhappy with this approach.

If you have any other solution also (other than using listboxes),
please let know

Thanks in advance for any & all help,
-feltra