LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
JNW JNW is offline
external usenet poster
 
Posts: 480
Default Weird option button behavior

I hope I can explain what's happening...
using vista and xl2007, but same thing happens in xp and xl2003.

I have a pair of option buttons on a worksheet that are yes/no answers to a
question. They are ActiveX option buttons. They have the same group name
and behave normally in that when you click the one for yes, the linked cell
changes to true (same for no). If yes is true, and you click no, then yes
changes to false and no changes to yes (works the other way around also).

The weirdness is that when you click the option button, and the linked cell
changes, the button itself does not appear to be clicked. And that's not
all! Generally if you click yes, then click yes again it just remains
clicked. These buttons, if you click yes, then click yes again then it
changes the linked cell to false the second time. This same behavior happens
with the no button.

I've searched in the code, and no part of the code refers to these cells or
option buttons.

I've got a number of sets of yes/no option buttons on the sheet and none of
the have the same problem. I tried deleting the buttons and inserting new
ones, and deleting and copying from another set on the sheet, but as soon as
I change the linked cell it reverts back to the strange behavior.

Has anyone seen this before? Even better, anyone have any ideas as to how
to fix it?

Hope that makes sense
 
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
Weird Macro Behavior Will Specht Excel Programming 2 September 25th 08 02:44 PM
Weird Do...Until behavior... IT_roofer Excel Programming 0 May 23rd 07 06:34 PM
weird macro behavior Dave F Excel Discussion (Misc queries) 0 November 30th 06 03:35 PM
Excel weird behavior [email protected] Excel Discussion (Misc queries) 4 May 25th 06 08:23 PM
Weird Sorting Behavior Jim Thomlinson[_3_] Excel Programming 1 May 4th 05 04:42 AM


All times are GMT +1. The time now is 02:23 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"