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

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
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,784
Messages
6,121,536
Members
449,037
Latest member
tmmotairi

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