ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Syntax for control source in combo box control (https://www.excelbanter.com/excel-discussion-misc-queries/239544-syntax-control-source-combo-box-control.html)

dhstein

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

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



Dave Peterson

Syntax for control source in combo box control
 
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


All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com