Sorry to hear that. Please make sure the formula is entered with you pressing the Ctrl + Shift + Enter keys. If the solution can't solve your proplem, please send us the screenshot of the details. Thanks!
Sorry I don't quite understand your description. Can you try to be more specific of it?
After applying the VBA code mentioned in the above method, when the cell with the data validation drop-down list is checked, the drop-down list turn into a combo box, and then all the items in the list are listed.