Does anyone else have problems ActiveX listbox controls changing size?

Question

I've recently been upgraded from Excel 2000 to Excel 2007. A problem I have is with ActivX listbox controls imbedded in a spread sheet.  When I open the file the deminsions of the list box (height & width) are smaller than they previously were.  I've found that if the file is saved and reopened several times, the listbox can srink down to almost nothing.  I've got a partial work around by programing in new properties when an item in the list is clicked.  But if the box has already shrunken to a size where a new selection can not be clicked, this won't work.

I've tried code that resized the controls when the worksheet was activated, but this triggers the event code from the list box with out a selection and that errors out.

Answer 1

Thanks, but this does mean that there is a significant bug in windows or excel.

I am running excel 2010 on windows 7 and have this bug.

I migrated my excel 2002 aps to excel 2010 only to have them become useless.

How do we respectfully ask microsoft to fix this soon?

dave

Answer 2

Thanks for the feedback Dave!  I'll defintely consider using the "Forms" controls on future projects.

I don't really want to get involved with deleting and recreating the existing ActiveX controls; I guess I just felt that Microsoft "should" provide a product that works! 

I was able to add code to the "click" event for these controls.  The code resizes the control and the other controls on the worksheet.  So as long as a selection can be made onone control, all controls will be accessable.

Best Regards

Answer 3

I think a lot of people have had trouble with these controls.

Sometimes, just deleting them and adding a fresh control back will fix the

problem (at least temporarily).

Me.  I like to use the controls from the Forms toolbar.  They offer lots less

customization, but they behave better.

BigToys wrote:

I've recently been upgraded from Excel 2000 to Excel 2007. A problem I have is with ActivX listbox controls imbedded in a spread sheet.  When I open the file the deminsions of the list box (height & width) are smaller than they previously were.  I've found that if the file is saved and reopened several times, the listbox can srink down to almost nothing.  I've got a partial work around by programing in new properties when an item in the list is clicked.  But if the box has already shrunken to a size where a new selection can not be clicked, this won't work.

I've tried code that resized the controls when the worksheet was activated, but this triggers the event code from the list box with out a selection and that errors out.

--

Dave Peterson