Using Form ListBox does not make much senseas just as well we haveData Validationallowing you to set a drop down list to any Excel cell. See my post onExcel Cascading Drop-downsif you want to see how powerful this can be. Beware in below examples I am using the ActiveX ListBox instead!