D dhstein Aug 12, 2009 #1 What is the Syntax for control source in combo box control? Sheets(???).Range("a2:a100") ?
D Dave Peterson Aug 12, 2009 #2 On a userform? me.combobox1.controlsource _ = worksheets("sheet1").range("A1").address(external:=true) but you may have meant .rowsource??? me.combobox1.rowsource _ = worksheets("sheet1").range("A2:a100").address(external:=true)
On a userform? me.combobox1.controlsource _ = worksheets("sheet1").range("A1").address(external:=true) but you may have meant .rowsource??? me.combobox1.rowsource _ = worksheets("sheet1").range("A2:a100").address(external:=true)
