Hi all,

I have MainLbx display a list of categories to select from. On Double-click,
MainLbx brings up the selections for only that category (say SODA as
category, Coke, Pepsi as selections).

When the user double-clicks on the item, it will be added to a cell in the
same worksheet. The problem is when the user first tries to doubleclick on an
item (after doubleclicking on the category), the listbox jumps to the third
selection in the row.

I have tried:

MainLbx.Selection(0) = True
MainLbx.ListIndex = -1

Thanks for the help!

Any suggestions would be appreciated!

Thanks,

"Kagan Clearwater" wrote:

Hi all,

I have MainLbx display a list of categories to select from. On Double-click,
MainLbx brings up the selections for only that category (say SODA as
category, Coke, Pepsi as selections).

When the user double-clicks on the item, it will be added to a cell in the
same worksheet. The problem is when the user first tries to doubleclick on an
item (after doubleclicking on the category), the listbox jumps to the third
selection in the row.

I have tried:

MainLbx.Selection(0) = True
MainLbx.ListIndex = -1

Thanks for the help!