Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes, the ActiveX controls I described are in a worksheet in Excel 2002.
After experiencing this, I too am going to use Forms controls whenever possible. I wonder what's up with Microsoft - if this type of thing reared its head in Excel 97, they must have known about it, and it's surprising they still haven't fixed it two major upgrades later. "Tim Zych" wrote in message ... Is this being used on a worksheet? The only time I saw this bug was while using XL97. I think the way I fixed it was to recreate the button and make it a bit larger/smaller until it no longer happened. ActiveX controls on worksheets can be finicky. I try to avoid using them wherever possible and use Forms controls instead. "Paul James" wrote in message ... I'll also mention that there's nothing in the code that's being run in the click event of these controls that affects the ActiveX objects themselves. That is, I'm not resetting any of the properties of the controls, or moving or resizing any ranges in the sheets where the controls reside. The code simply copies data from one place in the worksheet to another place. So I don't think the code that's being run is causing the bizzare behavior I've described. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ActiveX Controls | Excel Discussion (Misc queries) | |||
Tab between ActiveX controls | Excel Discussion (Misc queries) | |||
ActiveX controls | Excel Discussion (Misc queries) | |||
ActiveX Controls | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) |