Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LinkedCell Update does not always respond
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
LinkedCell Update does not always respond
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? -- Regards, Bill "Jeroen Kluytmans" wrote in message m... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
LinkedCell Update does not always respond
Bill wrote:
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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
LinkedCell Update does not always respond
<<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/d...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. -- Regards, Bill |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
LinkedCell Update does not always respond
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveX Combobox and LinkedCell | Excel Worksheet Functions | |||
ComboxBox with Dynamically Defined Source, and LinkedCell error | Excel Discussion (Misc queries) | |||
Combo Box "LinkedCell" option | Excel Discussion (Misc queries) | |||
Linkedcell protection problem | New Users to Excel | |||
Linkedcell Problems... | Excel Programming |