listbox control size (vba)

[mahr]

Hi,

I have an excel sheet, where i have about 10 activex command buttons forming a vertical menu. I have about 10 listboxes on top of each other. When i click a text box it populates the listbox with some data.

Now the problem is sometimes when i click on a button the list box loses its size and shrinks. This is what in buttons click event:

Please Login or Register  to view this content.

I tried setting the height width and top properties but doesn't seem to work. Any idea what i'm doing wrong?

Thanks in advance.
Addy

[Shampoo Monkey]

Hey Addy,

Is it just this particular button click event that adjusts the listbox size or does it happen when you click other buttons too? Is it just the one list box?

Other than the top/width/height that you have added in, I do not see a problem with that macro.

If you could add the portion of the file your having trouble with we might be able to narrow it down a bit more for you.