View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
L Mehl L Mehl is offline
external usenet poster
 
Posts: 73
Default ListBox has 2 rows highlighted

Adding
MsgBox Me.ListBox1.ListIndex
at the start of the listbox Click event
displays only 1 integer in the msgbox (0,1,2,...)
So, the system thinks only one listbox entry is highlighted, when two are
highlighted.

Me.Repaint has no effect when added at the end of the listbox Click event.
Is that where you thought I should put it?

Thanks for any additional help.

L Mehl

"Dave Peterson" wrote in message
...
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