Hi
I am looking for a macro that will pop up an input box so the user can add an item to a named range used in a drop down list. E.g. sheet one column A is populated via a named range called colours which has three items. If the user enters another colour (via and input box) in list box i need it to check it doesn't already exist and then add it to the list and increase the range for the list box.
Any help appreciated
Thank you
Mykal
I am looking for a macro that will pop up an input box so the user can add an item to a named range used in a drop down list. E.g. sheet one column A is populated via a named range called colours which has three items. If the user enters another colour (via and input box) in list box i need it to check it doesn't already exist and then add it to the list and increase the range for the list box.
Any help appreciated
Thank you
Mykal