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
