activex controls excel 2007 - Weird!

[michael.beckinsale]

Hi All,

For background - I am developing a spreadsheet that contains 3 active
x comboboxes, the source is a named range 3 columns wide, and the
combobox is set for 3 columns. On the development machine that l am
using the comboboxes display properly and react to events correctly.

The weird behaviour comes when l try to use the spreadsheet on a
laptop or some different sized screen. In the case of the laptop the
comboboxes appear to have resized correctly but once they react to the
events the text gets smaller but the combobox size remains the same!
To make matters worse each time an item in the list is selected the
text gets smaller again!

I have tried all the usual suspects, move and size with cells, move
but dont size with cells, lock aspect ratio etc but the problem
persists.

Can anybody shed any light on this problem?

Reagrds

Michael

 

[Patrick Molloy]

this is a problem with ActiveX controls on older versions too. I've amended
most of my spreadsheets to use the excel forms objects instead of the ActiveX
controls...they're pretty weeird sometimes

Patrick

 

[michael.beckinsale]

Patrick,

Thanks for the feedback.

I try to avoid using ActiveX controls but sometimes you just need that
extra bit of flexibility and in this case thats just what l need!

It seems to me from the research l have done over the past few hours
that it is quite well known in the 'developer' community that these
controls are 'flakey' when used on the sheet itself but more reliable
when used on a userform, which in this case is not an option.

In my opinion Microsoft are not doing themselves any favours making
ActiveX forms available for sheet use when it is evidently known to be
unreliable, surely a product as widely used as Excel should not have
inherent 'bugs' over several releases / generations - perhaps that is
why there is so little information on the Microsoft web site about
this subject!

Regards

Michael