I haven't programmed in Excel for a while and I have a task set for me. I have a macro which inserts a new row, copying only the formats, formulas and objects from the previous row. All is fine, except the combo box which it copies has a linked cell and when it is copied to the new row the linked cell doesn't change. I need to somehow manipulate the combo box programmatically so as I can change the LinkedCell property.
The form which I'm working on has been set up using combo boxes, not ActiveX Controls, and I really dont want to change all of them if I don't need to.
Please help me!
Ally
The form which I'm working on has been set up using combo boxes, not ActiveX Controls, and I really dont want to change all of them if I don't need to.
Please help me!
Ally