ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ComboBox Items (https://www.excelbanter.com/excel-programming/285415-combobox-items.html)

Todd Huttenstine[_2_]

ComboBox Items
 
I have a combobox and I forgot how to add values to it
without having to reference a range to get the values.
For instance I want to add the values: Percentile,
Numbers, and Top, and Worst.

Thanx

Todd Huttenstine[_2_]

ComboBox Items
 
I got it. This is what I am using.


ComboBox1.Value = "Please Select"
ComboBox1.AddItem "Best Performing (%)"
ComboBox1.AddItem "Worst Performing (%)"
ComboBox1.AddItem "Best Performing (Number)"
ComboBox1.AddItem "Worst Performing (Number)"


-----Original Message-----
I have a combobox and I forgot how to add values to it
without having to reference a range to get the values.
For instance I want to add the values: Percentile,
Numbers, and Top, and Worst.

Thanx
.



All times are GMT +1. The time now is 12:34 PM.

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