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

Weird option button behavior
 

Hello JNW,

In my experience, it is never a good idea to use linked cells with
ActiveX objects on a worksheet. There seems to be an inherent
communication problem. If you don't need the event capabilities of the
ActiveX control, use a Forms Toolbar control instead.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48332

Weird option button behavior
 

Unfortunately I am using the events. I got it to work by inserting a new row
and moving everything to that row. It appears as if there was something
trapped in Excel's memory having to do with those particular cell
references...

"Leith Ross" wrote:


Hello JNW,

In my experience, it is never a good idea to use linked cells with
ActiveX objects on a worksheet. There seems to be an inherent
communication problem. If you don't need the event capabilities of the
ActiveX control, use a Forms Toolbar control instead.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48332

Weird option button behavior
 

A little late now, but if it happens again, check the precedients and
dependents to see if they have links for other than the option buttons.

"JNW" wrote:

Unfortunately I am using the events. I got it to work by inserting a new row
and moving everything to that row. It appears as if there was something
trapped in Excel's memory having to do with those particular cell
references...

"Leith Ross" wrote:


Hello JNW,

In my experience, it is never a good idea to use linked cells with
ActiveX objects on a worksheet. There seems to be an inherent
communication problem. If you don't need the event capabilities of the
ActiveX control, use a Forms Toolbar control instead.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48332

Weird option button behavior
 

Good thought. That was one of the things I tried, and there is a formula
that is dependent on the cells but it merely checks to see if filled out.
This is also done on every other yes/no question.

Thanks for the suggestion.

"JLGWhiz" wrote:

A little late now, but if it happens again, check the precedients and
dependents to see if they have links for other than the option buttons.

"JNW" wrote:

Unfortunately I am using the events. I got it to work by inserting a new row
and moving everything to that row. It appears as if there was something
trapped in Excel's memory having to do with those particular cell
references...

"Leith Ross" wrote:


Hello JNW,

In my experience, it is never a good idea to use linked cells with
ActiveX objects on a worksheet. There seems to be an inherent
communication problem. If you don't need the event capabilities of the
ActiveX control, use a Forms Toolbar control instead.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48332