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

2 replies

by wordworker

Not sure what you mean by an "object". How about just creating a Data Validation rule with the four items entered as a list. Then you can copy that first cell to the 180 row range, and the validation rule will apply to all destination cells.

by sarahsway

Yes indeed. By object I meant a drop down control box. Something a co-worker was working on and ask for my help. I did suggest using the list box through a Data Validation rule and then copied down just as you suggested. Works great and much neater. Thanks again for taking the time to resond.

This discussion is closed to new replies.