Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo boxes go all funny!
Using Excel 2003 SP3. My combo boxes are going all funny! For no
reason (?) they get smaller and the fonts get bigger/smaller/wider (and I have to replace them with new ones and it happens again!). Does anybody know why this is happening please? Thanks Hiran |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo boxes go all funny!
Right click the combo box and select Format Control. Chech the size tab and
uncheck lock aspect ratio if it is checked or the more likely cause is on the Properties tab. Change the radio button settings as needed... -- HTH... Jim Thomlinson "Hiran" wrote: Using Excel 2003 SP3. My combo boxes are going all funny! For no reason (?) they get smaller and the fonts get bigger/smaller/wider (and I have to replace them with new ones and it happens again!). Does anybody know why this is happening please? Thanks Hiran |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo boxes go all funny!
Thanks Jim.
Actually this is one of the controls in View Toolbars Control Toolbox - (not Forms). My problem looks like a corruption in some way, but I don't know what - a bug in Excel? In my client's installation? Resources on PC? The corruption gets 'saved' when you save the file. Any thoughts anyone? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo boxes go all funny!
On Aug 8, 7:59*am, Hiran wrote:
Using Excel 2003 SP3. My combo boxes are going all funny! For no reason (?) they get smaller and the fonts get bigger/smaller/wider (and I have to replace them with new ones and it happens again!). Does anybody know why this is happening please? Thanks Hiran go into format control (right click on combobox) and go to properties and choose "object positioning: Don't move or size with cells" |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo boxes go all funny!
Put your worksheet in design mode and right click on the combo box. Now
select Format Control... and check the size and properties. -- HTH... Jim Thomlinson "Hiran" wrote: Thanks Jim. Actually this is one of the controls in View Toolbars Control Toolbox - (not Forms). My problem looks like a corruption in some way, but I don't know what - a bug in Excel? In my client's installation? Resources on PC? The corruption gets 'saved' when you save the file. Any thoughts anyone? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo boxes go all funny!
Jim and MD,
I have tried to adjust the offending properties (size, font, font size etc) in the properties tab BUT ALAS this problem is something really odd - the 'corruption' persists. Open to any other suggestions ... (Monday 11 Aug) New info - the PC that was doing this to these controls isn't doing it today, so it's intermittent. It'll be nice to know why it happens though. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
Can't get rid of funny little boxes in imported data | New Users to Excel |