VBA Dropdown change list Entries automatically
I would like to know how i would go about changing a dropdown box in mulitple documents and change the name of the dropdown name.
currently the dropdown is named 'dropdown1' it needs to be changed to 'drpVessel'.
does any one have any suggestion the best way around this?
|