Posted by Hock on July 05, 2000 12:43 AM
I'm trying to create a data entry sheet with each row as a record, and each column within the row as a field. For some of these fields, I do not want the user to key in text freely, but rather, I want them to select from a combobox, i.e. select from a drop down listbox.
I've done that for a row. Now I want to duplicate that row 1000 times. However, I find that when I copy and paste, the LinkedCell property of the combobox does not change. Eg. in Cell B3, I create a combobox and the LinkedCell property of that combobox is set to return the selection value back to cell B3. When I copy row 3 and paste it to row 4, the LinkedCell property of the combobox in row 4 still refers to cell B3. For normal formulas, Excel would have changed it automatically to refer to B4 instead.
Any ideas on how to solve this? I wouldn't want to manually edit the LinkedCell property for 1000 rows.