| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Syntax for control source in combo box control
What is the Syntax for control source in combo box control?
Sheets(???).Range("a2:a100") ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| control toolbox combo box | Excel Discussion (Misc queries) | |||
| Syntax to return the value of a control by reference | Excel Discussion (Misc queries) | |||
| "Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
| "Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
| Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) | |||
Linear Mode
