Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Combo Box to Column of Data
Question: How do I reference a list of data from a column in a combo box
I have a drop down menu in a Form, I figure use a combo box I'd like to have it reference a specific name range in a sheet or Column for instance. I'll have apples, pears, peaches, etc in Column B So if a user changes column B then the combo box will reflect that change when it's opened. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference Combo Box to Column of Data
You can use the Userform_initialize event to populate the values into that
combobox. One way is: Option Explicit Private Sub UserForm_Initialize() With Worksheets("Sheet1") Me.ComboBox1.List _ = .Range("b1", .Cells(.Rows.Count, "B").End(xlUp)).Value End With End Sub But there are lots of other ways, too. They can be useful if want to format the values in the combobox (money/time/dates) or want to skip cells that don't meet a certain criteria. Benjamin wrote: Question: How do I reference a list of data from a column in a combo box I have a drop down menu in a Form, I figure use a combo box I'd like to have it reference a specific name range in a sheet or Column for instance. I'll have apples, pears, peaches, etc in Column B So if a user changes column B then the combo box will reflect that change when it's opened. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to reference to a column of data? | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
Select all data in column and list in form combo box | Excel Programming | |||
how do I reference data from a Combo Box? | Excel Programming | |||
Grabbing Data From Second Combo Box Column | Excel Programming |