Hello everyone,
I needed to implement autocomplete for my Dropdowns and I used the ComboBox method. I followed the instructions from this website: http://www.contextures.com/xlDataVal11.html
Everything is working fine but now I need to show a warning and insert the value in another cell every time the user tries to enter a value that does not get matched in the list. Can someone tell me how to do this, please? Thanks in advance!
I needed to implement autocomplete for my Dropdowns and I used the ComboBox method. I followed the instructions from this website: http://www.contextures.com/xlDataVal11.html
Everything is working fine but now I need to show a warning and insert the value in another cell every time the user tries to enter a value that does not get matched in the list. Can someone tell me how to do this, please? Thanks in advance!