select item from combobox

  • name range "itemname" contain 5 item and combobox TB1. i need to
    how to select only define item from combobox TB1 for range name "itemname" in userform in excel otherwise TB1 setfocus and also reset button when user click reset button combobox TB1 is "" .

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!