item selected in a listbox

S

SUZYQ

I have a multi-select listbox filled with error messages that a user
can select. For a few of the error messages I need to prompt for
additional information.

I'm using the click event of the listbox and then capturing
Me.lstSubType.Column(0). If it's one of the ones I'm interested in,
then at that point a InputBox prompts the user for information.

The problem that I'm having is that the user is prompted even if they
de-select the item.

How do I only prompt for the additional information when the item is
actually selected/highlighted?

Thanks!
 
J

Jackie L

Try putting your check/condition on the After Update event of the combo box
instead.

Hope this helps.
 
Top