List Box size mystery

KatyJohn

New Member
Joined
Jan 25, 2009
Messages
41
I have 4 activeX List boxes on a page that will not stay the same width. I use property to adjust the size, but the width will unexpectantly change. I don't have a clue why this is happening.

katy John
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Mickerickson

I don't see an autosize in the property dropdown, but there is a forms control which may have something to do with it. I have activeX comboxes in another section and they have stayed the same size.

katyjohn
 
Upvote 0
If you have forms controls, have you right clicked the box and set Properties to "Don't move or size with cells?"
 
Upvote 0
Mickerickson

Looks like that was the solution. I don't why it just effects the List Boxes and not the Combo Boxes. But not to worry.

Thanks for your input

KatyJohn
 
Upvote 0
Forms controls are not ActiveX controls. If your comboboxes are ActiveX from the Toolbox and the listboxes are from the Forms menu, that may be why they act differently.
 
Upvote 0

Forum statistics

Threads
1,214,411
Messages
6,119,356
Members
448,888
Latest member
Arle8907

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top