Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
forcing excel to update the Cell Link when copying Combo Boxes
I am using combo boxes to enter information. Directly under each combo box is
the "Cell Link" cell for that combo box. When I copy the row down, the combo box copies down with it's Cell Link cell, as expected. However, the new combo box is still linked to the origional cell, and must be altered manually to link to the new "Cell Link" cell. Is there any way to force excel to automatically update the address of the "Cell Link" to the new (destination) cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
link cell in excel to current date | Excel Discussion (Misc queries) | |||
Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
Excel should let me link one cell to another. | Excel Worksheet Functions | |||
EXCEL LINK CELL FORMULA | Excel Worksheet Functions |