Discussion Locked
Excel 97 - Copying controls to multiple locations
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am working on a new form in Excel 97. I am including a drop down box that has 4 items. I would like to have the control in approx. 180 rows. I would like to be able to copy the control to all 180 rows at the same time. Since this is an object, how can I copy it down through the rows at once. It can be individually pasted by lazy me would like to be able to do it at once