I have an excel macro using which I created a Drop Down Box (the drop down box has the selections that I specified in the Macro). However, If I manually try to write something in the Drop Down Box then I get an Error Message. Is there a Macro to Fix this. Please see example below:
Cell A1 has the Drop Down Box with four Choices (i.e. A, B, C, D), however there could be instances where I would need to manually enter my own choice that is not available in the Drop Down List. When I double click the CELL A1 to type in my own selection and not from the list. Is there a Macro that will allow me to type my own selections as well as choose fromt he existing selection of A,B,C,D. Also I would like the entire column of A have the drop down box for a selection of cells in A.
I want users to have the option of either selecting from the drop down list or be able to edit the cell and type there selection. Please see the Macro that I currently have:
Bookmarks