LinkedCell Update does not always respond

[Jeroen Kluytmans]

Hi all,

I made some checkboxes on sheet1, these checkboxes are controlled by a
LinkedCell on sheet2, however, when the values on sheet2 do change,
these values are not always updated in the checkboxes on sheet1. This
seems to happen randomly. Does anybody have a clue how this can happen
or how to solve it (e.g. force update of values?)

Kind regards,
Jeroen Kluytmans

 

[Bill Renaud]

Do you have all of the Service Packs installed? What version of Excel are
you using? (Use Excel|Help|About and copy the entire first line of the
message box.)

The value on sheet2 should be a boolean value (TRUE or FALSE). I don't know
how well it works if you try to put 1 or 0 in the cell that is linked to the
checkbox on sheet1. I'm assuming that you are using the checkbox control
from the Forms toolbar, not one from the Control Toolbox (ActiveX) toolbar.

Are you running a VBA macro that might be attempting to enter a value into
the linked cell on sheet2?

 

[Jeroen Kluytmans]

Do you have all of the Service Packs installed? What >version of Excel

are you using? (Use Excel|Help|About and > copy the entire first line of
the message box.)

I think all service packs are installed, Version Microsoft Excel 2000
(9.0.3821 SR-1)

The value on sheet2 should be a boolean value (TRUE or >FALSE). I don't

know how well it works if you try to put 1 > or 0 in the cell that is
linked to the checkbox on

sheet1.

I don't know I don't get a 0 or 1 in these cells

I'm assuming that you are using the checkbox control
from the Forms toolbar, not one from the Control Toolbox .
(ActiveX) toolbar.

I am using the ActiveX Checkbox

Are you running a VBA macro that might be attempting to >enter a value

into the linked cell on sheet2?

Yes I do, I each time copy a formula (the same) in the linked cell,
however, the value does not change because of this. I need to copy this
formula each time, otherwise the ranges do change. However, how does
this effect the controll of the checkboxes?

Kind regards,
Jeroen Kluytmans

 

[Bill Renaud]

<<I think all service packs are installed, Version Microsoft Excel 2000
(9.0.3821 SR-1).>>

You may not have all service packs installed. I also use Excel 2000, and
mine is at 9.0.6926 SP-3. For details about SP-3, see
http://www.microsoft.com/downloads/...70-47D0-4306-9FA4-8E92D36332FE&displaylang=en
I am not sure what the difference between a Service Release (SR) and a
Service Pack (SP) is, unless Microsoft has simply changed the way they name
their updates.

<<I am using the ActiveX Checkbox. I each time copy a formula (the same) in
the linked cell, however, the value does not change because of this. I need
to copy this formula each time, otherwise the ranges do change. However, how
does this effect the controll of the checkboxes?>>

This may be the problem. You should NOT be storing a formula in the linked
cell, because then Excel will use the formula to overwrite the value written
by the checkbox the next time that the worksheet is recalculated. If you
have a macro that is constantly restoring the formula in the linked cell,
then your checkbox effectively has no control! My tests bear this out.

The checkbox should simply save the value (TRUE or FALSE or #N/A!, if it is
a tri-state checkbox) to the linked cell on the same worksheet that contains
the checkbox. Your worksheet should then use this value to do whatever it is
going to do with the checkbox value. If you are only using the ActiveX style
checkbox to run event handlers to carry out actions, then leave the Linked
Cell property blank and just use the Value property of the checkbox.

 

[Jeroen Kluytmans]

Bill,

Thanks for the tips. i found a way around, I update all ranges each
time a checkbox is clicked or another element on the worskheet
changes, takes some typing work, but it works fine now.

Thanks again
Jeroen