ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   determine dropdown value (https://www.excelbanter.com/excel-programming/415558-determine-dropdown-value.html)

geebee

determine dropdown value
 
hi,

i would like to know how i can determine/display the value selected from a
dropdown box.

thanks in advance,
geebee


Office_Novice

determine dropdown value
 
If your DropDown is a comboBox from the control ToolBox you have a Couple of
options:

ComboBox1 .AddItem "Your First Item" ' To Add one at a time

Or ComboBox1.RowSource = "A1:A10" 'To Add from a sheet

There are a few other ways to populate a comboBox but these will get you
started.

"geebee" wrote:

hi,

i would like to know how i can determine/display the value selected from a
dropdown box.

thanks in advance,
geebee



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

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