rename dropdown box

[hawley]

I am using Excel 97.

From the Forms toolbar I added a combo box to the excel sheet. It gives me a default name of "Drop Down 2". I want to change this name but not sure how.

I have two sheets that look identical but the names of some of the drop downs are different and I need to make them the same. I have tried coping the sheet but I am always one number off on one dropdown. The other names are the same just that one. I have looked on the sheet too and can not find a dropdown with the same name.

Help me before I go crazy. Thanks!!!!!

 

[Bowers74]

You can change the name by using the name box. Just Type the name that you wish to give each object once it is selected. You can't have objects of the same name on the same sheet though.

Name Box

I hope this helps!



Peace!!

Mike

Didn't get the answers that you wanted? Then . . . Click Here