ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   forcing excel to update the Cell Link when copying Combo Boxes (https://www.excelbanter.com/excel-worksheet-functions/109675-forcing-excel-update-cell-link-when-copying-combo-boxes.html)

Baraki0568

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?


All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com