ListBox Sizes

[KiwiDave]

Hi, I am not fluent in vba. I have a worksheet that has 7 List Boxes on it. Depending on the pc, the List Boxes keep changing their size. I've seen a lot of comments about adjusting the properties but it seems that I should define the exact size of each list box. I know I have to DIM them, but I don't know how. I know there are properties (Height, Left, Width and Top) but what is the syntax to make that happen? I am guessing that I need to DIM each list box but what is that code and where do I put it so that it runs every time I run the programme?

 

[fadee2]

how about, selecting all your listboxes and right click > Size and Properties and under properties, select donot move or resize with cells.

hth....

 

[KiwiDave]

Thank You fadee2. I did try that first, I also unchecked the 'Lock Aspect Ratio'. The issue of the listboxes changing sizes seems to occur whenever the screen size changes from 100%.

I want to use VBA to resize and position the Listboxes everytinme the programme opens.

Is that possible? Where to I place the code to make it happen?

Regards
David