Hi,

I wonder if there is any way to only allow 1 combo box to be fill?
I have 5 combo box,:
cmbRef, cmbName, cmbId, cmbProfession, cmbSalary and a command button as object in worksheet.

By pressing the command button, if only 1 combo box is filled, it will messagebox "Good". If more than 1 is filled, it will messsage box "Only 1 allowed".

Thanks.