Listbox Item Focus  
Author Message
Folderscom





PostPosted: Thu Apr 05 14:12:02 CDT 2007 Top

Excel Programming >> Listbox Item Focus

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!

Excel434  
 
 
KaganClearwater





PostPosted: Thu Apr 05 14:12:02 CDT 2007 Top

Excel Programming >> Listbox Item Focus Any suggestions would be appreciated!

Thanks,



> 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!