Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
3 option boxes to linked cell-linked cell to be 1,2,3.
I have worksheets full of checkboxes grouped in 3s (Yes, No, N/A). They are
linked to a cel and it is 1,2,3. I have a formula attached to 1,2,3. The problem is, on a worksheet instead of 1,2,3, a linked cell reads 4,5,6. I have to have them all read 1,2,3 because I have a macro that defaults to 2. I have removed checkboxes, group box, reset them, made them smaller, deleted them, then rewrote them, all to no avail (these things have helped in the past). Does nayone know the reason they do this and can tell me how to fix it? Thanks, Paula |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
3 option boxes to linked cell-linked cell to be 1,2,3.
I am not sure that I understand the problem, but Excel automatically assigns
index nujmbers to objects as they are added to a collection on a worksheet. Although you might have 12 checkboxes grouped in threes in a frame, Excel still sees them as Checkbox1 thru Checkbox12. Otherwise, it would be difficult to know which Checkbox is being referred to for execution or value. "Paula" wrote in message ... I have worksheets full of checkboxes grouped in 3s (Yes, No, N/A). They are linked to a cel and it is 1,2,3. I have a formula attached to 1,2,3. The problem is, on a worksheet instead of 1,2,3, a linked cell reads 4,5,6. I have to have them all read 1,2,3 because I have a macro that defaults to 2. I have removed checkboxes, group box, reset them, made them smaller, deleted them, then rewrote them, all to no avail (these things have helped in the past). Does nayone know the reason they do this and can tell me how to fix it? Thanks, Paula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP...Draging cell without changing Formula linked to cell | Excel Discussion (Misc queries) | |||
Option box text - linked to cell | Excel Programming | |||
How do I have a linked cell auto-size to fit the linked data? | Excel Discussion (Misc queries) | |||
How to force a cell value to change if Linked cell moves? | Excel Discussion (Misc queries) | |||
Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) |