Help! Jumping ListViews!

[Duncan]

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!

 

[Nigel]

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?

 

[Duncan]

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
(e-mail address removed)

Thanks Nigel; yes setting the top and left values has no effect as
they become ignored. For future usenet reference after a bit of
fiddling I found a workaround;

ListView1.Visible = False
ListView1.ListItems.Clear
ListView1.Visible = True
ListView1.Visible = False 'extra command
ListView1.Visible = True 'extra command

This seems to do the trick. )

 

[Anthony Ryan]

It does the same thing in xl2003. My listview control has checkboxes and
these blank out as well. I will try your solution below.

Thanks
Anthony