VBA to add to Data Validation List
Posted on 2013-11-01
Is there any code that I can use to add items into an existing Drop down List?
I have a list in a Sheet named Static Data [which is a hidden sheet]. The List Name is Responsibility and the data for this is in column H.
The user uses a sheet called Deliveries and I would like to add a button on this sheet that will call the macro to give the user the opportunity to add additional Names in the List.