ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   combo box (https://www.excelbanter.com/excel-programming/372897-combo-box.html)

Ernie

combo box
 
how can i make my combobox get its list from cell A1 to A10?

NickHK[_3_]

combo box
 
Set the ListFillRange property of the combobox on a worksheet.
Or the .RowSource property if on a userform.

NickHK

"ernie" ...
how can i make my combobox get its list from cell A1 to A10?




Ernie

combo box
 

How do i specify the worksheet in the .RowSource property


"NickHK" wrote:

Set the ListFillRange property of the combobox on a worksheet.
Or the .RowSource property if on a userform.

NickHK

"ernie" ...
how can i make my combobox get its list from cell A1 to A10?





NickHK[_3_]

combo box
 
As I only learned the last week :
Sheet1!A1:A10.

NickHk

"ernie" ...

How do i specify the worksheet in the .RowSource property


"NickHK" wrote:

Set the ListFillRange property of the combobox on a worksheet.
Or the .RowSource property if on a userform.

NickHK

"ernie" ...

how can i make my combobox get its list from cell A1 to A10?







Ernie

combo box
 
Thank You


"NickHK" wrote:

As I only learned the last week :
Sheet1!A1:A10.

NickHk

"ernie" ...

How do i specify the worksheet in the .RowSource property


"NickHK" wrote:

Set the ListFillRange property of the combobox on a worksheet.
Or the .RowSource property if on a userform.

NickHK

"ernie" ...

how can i make my combobox get its list from cell A1 to A10?








All times are GMT +1. The time now is 11:53 PM.

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