Excel and combo box

[vishwakrishnan]

Hi all,

I am desigining a form in Excel.There are some fields where you have to enter date month and year.

I have used combo box for selecting date month and year as shown in the word document attached.

These fields are appearing more than six places in the form.Do i have to create combo box for each time or is there any way to copy the combo box already created and replicate it in all other places.

 

[MGumbrell]

I use the copy and paste method and also ensure that the range (assuming you are doing this) I am sure that its a case of right click on the combobox and paste elsewhere. The combobox automatically asigns a new name in numerical order.

Hope this helps, Matt