Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Crazy Combobox
I have a nutty combobox that is doing my head in
It is a control toolbox combo rather than a form one. The linked cell sits behind the combobox. Using Excel 97 on Win 2000 I have tried out this worksheet on 2 different PCs (same settings) On 1 PC, when I initialy had the control set so that it would print, the control printed really really tiny for some reason (??) - if it didn't then that would be all I needed. So that is when I made the linked cell sit behind the combo. I made the combo not print (format control) - but then, although perfect on print preview, it crashed Excel when I tried to print. (an error in excel.exe stuff, closed down Excel on it's own) I then tried it on the second PC. Here it didn't crash when printed, but every time you make a change on the combo it seemed to make the box a little smaller - until it was so tiny you could hardly select it. (there was nothing about the combobox size in the on_change VB By the way, autosize is set to false Doing my head in. This will be sent out to loads of external hospitals Can you help? If I could get round the first problem - i.e. have the combo print at the size seen in normal view that would be all I need (I would have the linked cell somewhere other than behind the combo). Otherwise... well, any ideas what I can change to stop the mad things happenning. Why does it act differently on different machines that are set up the same Thanks for any suggestions Basil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Crazy Combobox
I use now controls from the Forms toolbox whenever possible, the others
are bug ridden and tend to give problems as you describe. Not so pretty - but leads to a quieter life. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
Crazy If | Excel Worksheet Functions | |||
CONCATENATE CRAZY! | Excel Worksheet Functions | |||
I'm going crazy here | Excel Discussion (Misc queries) | |||
This is crazy!!! | Excel Discussion (Misc queries) |