Hi,
I am using a combo box on a userform that is linked to a range in my worksheet.
Currently the user can type what ever they want into the combo box, even if it is not in my range.
How can i validate the combo box so that the user is only able to select an entry from the drop down list i.e my range.
many thanks
I am using a combo box on a userform that is linked to a range in my worksheet.
Currently the user can type what ever they want into the combo box, even if it is not in my range.
How can i validate the combo box so that the user is only able to select an entry from the drop down list i.e my range.
many thanks