Active-X Listbox on worksheet

[dave8]

I have two listboxes on a worksheet and using VBA to load values into the listbox. I also have a combobox that is used to determine what values are to be displayed in the listboxes. I select a value from the dropdown list and depending on the value selected, a list gets populated in the listbox. This works just fine.

The problem I'm having is that when I adjust the zoom on the worksheet, 75% for example, the listbox automatically changes the width when new values are displayed. I try using the listbox1.width = xxx, to keep the width in place, but that doesn't really work. Does anyone know why this happens?

 

[JLGWhiz]

Try changing the integral height to 'False'.

 

[dave8]

Try changing the integral height to 'False'.

That worked. Thank you.

 

[JLGWhiz]

That worked. Thank you.

You're welcom,

Regards, JLG