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(exte rnal:=true)




dhstein wrote:

What is the Syntax for control source in combo box control?

Sheets(???).Range("a2:a100") ?

--

Dave Peterson