Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Magic Shrinking Listbox
We have an ordinary worksheet with an ActiveX listbox
from the Control Toolbox on it. The listfillrange is dynamic - ie its linked to a table that can grow or shrink. The odd thing is that everytime a recalculation is done, even if its a different sheet, the physical size of the listbox shrinks a bit each time. As far as I can see, there's no hidden code or anything. Tthe sheet zoom is 100%. If we set the width and height properties of the listbox, it still shrinks. This is only for one particular workbook - I cannot replicate the strange behaviour on another workbook. OS XP Pro, Excel XP Any thoughts would be most welcome Patrick Molloy Microsoft Excel MVP |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Magic Shrinking Listbox
Never seen that. However as a side note I did see some similar behaviour
only on the same setup you describe (XP, Excel XP). My worksheets contained standard validation dropdowns in one column and around 5 or so ActiveX command buttons. The ActiveX command buttons would shrink in height (from around 128 pixels tall to about 32) and the drop downs would not function. The workbooks were written inhouse and had nothing in the way of startup or event code etc. Couldn't replicate the behaviour on any other setup. -- Regards, Bill Lunney www.billlunney.com "Patrick Molloy" wrote in message ... We have an ordinary worksheet with an ActiveX listbox from the Control Toolbox on it. The listfillrange is dynamic - ie its linked to a table that can grow or shrink. The odd thing is that everytime a recalculation is done, even if its a different sheet, the physical size of the listbox shrinks a bit each time. As far as I can see, there's no hidden code or anything. Tthe sheet zoom is 100%. If we set the width and height properties of the listbox, it still shrinks. This is only for one particular workbook - I cannot replicate the strange behaviour on another workbook. OS XP Pro, Excel XP Any thoughts would be most welcome Patrick Molloy Microsoft Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shrinking Listbox from Control Toolbox | Excel Discussion (Misc queries) | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
IDE add-on VB Magic? | Excel Discussion (Misc queries) | |||
Magic Cells | Excel Discussion (Misc queries) | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |