LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default Strange behavior in Excel 2003

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange Excel behavior please Help FcoMariscal Excel Discussion (Misc queries) 1 July 19th 08 08:22 PM
Excel Theme Colors Strange Behavior jen Excel Discussion (Misc queries) 0 July 11th 08 07:04 PM
Excel 2007 strange behavior on two computer kurlisue Excel Discussion (Misc queries) 1 April 21st 08 09:21 PM
Strange listbox behavior in version 2003 after version 2007 Russ Excel Programming 1 February 20th 07 03:35 PM
Excel Mac OS X - Strange Behavior BrianP Excel Discussion (Misc queries) 0 January 1st 06 08:07 AM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"