View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default Help! Jumping ListViews!

Listview control v6 in xl2007 does the same for me.

It is the Clear action that causes the control to move.

If the control is visible and I clear it, it does not move. If it is not
visible and I clear it then it does move

What is even more curious is that the Left and Top values are not changed!

Do not know why?

--

Regards,
Nigel




"Duncan" wrote in message
ups.com...
I'm writing some code on a userform that uses listview boxes.

Strangely the following code make the listview move around the form;

ListView1.Visible = False
ListView1.ListItems.Clear
ListView1.Visible = True

Can anyone else repeat this, and is there a workaround? (Obviously the
program is more complicated than this but it needs to selectively
hide listviews, change them and reveal them based on changing customer
selections).

Thanks everyone!