Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activex controls excel 2007 - Weird!
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
activex controls excel 2007 - Weird!
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" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
activex controls excel 2007 - Weird!
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX controls from 2007 not compatible in 2003 | Excel Programming | |||
No ActiveX controls when reading 2007 file formats into Excel 2003 | Excel Discussion (Misc queries) | |||
Activex controls in Excel 2003 | Excel Worksheet Functions | |||
Saving Excel with ActiveX controls | New Users to Excel | |||
Tab between ActiveX controls on an Excel worksheet | Excel Programming |