View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_8_] kirkm[_8_] is offline
external usenet poster
 
Posts: 166
Default Selected... or not ??

On Wed, 03 Jun 2009 21:08:13 -0500, Dave Peterson
wrote:
Hi Dave,

Thanks for that suggestion. I spent several hours
playing around... it showed the Change event was fired
more than once, and that my List Enter and Userform
Initialise code wasn'tt running every time. I can't fathom why
things work differently with a temp STOP command, than without one.

Anyway, I moved the form Initialise and List enter stuff into a
module, so I know it's runs once, reliably.

This produced a marqee-only every time, but the following
Selects it -

Private Sub List1_Enter()

Me.List1.Selected(0)) = False
Me.List1.Selected(0) = True

Exit Sub

Doesn't make sense to me... but this seems to do the trick

Thanks - Kirk