Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Anybody else know about this? Is this a well-known bug that I am just now
encountering? No. No. If you'd like to send me a simple example that demos the problem I'd be happy to look at it. However I've used these controls in both versions for many years and not seen any problems like you've experienced. Oh, please, Alan and everyone - when you post about option buttons and check boxes PLEASE mention which toolbar they come from. There are two types - Forms toolbar and Control Toolbox and they are way different. -- Jim "The poster formerly known as Colleyville Alan" wrote in message ... |I recently posted about an application that I developed in Excel 2000 that | did not work in Excel 2003. For one thing, the checkbox.name property in | Excel 2000 is not available to VBA in 2003. I was able to get the name by | checking the object type and if it was a textbox, getting the object name. | | It seems strange that MS would remove the name property from VBA, but here | is something even more strange. I had code that looped through all of the | objects on the screen. It would test the object using the "typeof" command. | If the object was a textbox, it did one action, if not, the action was | skipped. This, too, worked fine in Excel 2000. However, in Excel 2003, | when the code looked at an OptionButton and tested to see if it was a | CheckBox, the result came back True! | | If the progam was looking at a CheckBox and I asked if it was an | OptionButton, I would get a value of False. But when it looked at | OptionButtons and asked if they were CheckBoxes, it said true. So I had two | if statements, one that had a goto <label built-in in case it was an | OptionButton and the second one for the normal processing. I did not have | anything this strange happen in Excel 2000. | | Anybody else know about this? Is this a well-known bug that I am just now | encountering? | |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Strange Excel behavior please Help | Excel Discussion (Misc queries) | |||
Excel Theme Colors Strange Behavior | Excel Discussion (Misc queries) | |||
Excel 2007 strange behavior on two computer | Excel Discussion (Misc queries) | |||
Strange listbox behavior in version 2003 after version 2007 | Excel Programming | |||
Excel Mac OS X - Strange Behavior | Excel Discussion (Misc queries) |