Copying & Pasting Controls

ofthe3rdkind

New Member
Joined
Oct 12, 2006
Messages
1
I am creating a worksheet with several hundred lines. The worksheet will feature a conbo box on each row for selecting data. When I copy and past the combo box, the "cell link" under the controls tab (format controls) shows the older linked cell -- not the new linked cell.

Do I have to go and change several hundred format controls or is there an easier way?

Thanks!
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,831
Office Version
  1. 365
Platform
  1. Windows
What is the combobox being used for?

Couldn't you use Data>Validation... with the List option?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,989
Messages
5,526,091
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top