View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kagan Clearwater[_2_] Kagan Clearwater[_2_] is offline
external usenet poster
 
Posts: 3
Default 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!