View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default ListBox has 2 rows highlighted

It sounds like it's a display problem.

Maybe you could verify it with a line like:

MsgBox Me.ListBox1.ListIndex

And if maybe you could refresh the user form with a line like:

Me.Repaint





L Mehl wrote:

Hello --

A form contains 2 listboxes.

Listbox1's MultiSelect property is set to
frmMultiSelectSingle.

The choice from that listbox is used to populate Listbox2.

If the choice in Listbox1 results in Listbox2 having no records, clicking a
different choice in Listbox1 highlights both the original choice and the
second one.

Is there a setting or code I need to add to allow only one choice (or, none)
in Listbox 1 to be highlighted?

Thanks for any help.

Larry Mehl


--

Dave Peterson