Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox with columns
I have a combo box on my form with 12 columns. The items
are added down in the first column when I use the following code: combobox1.add item var1 combobox1.add item var2 combobox1.add item var3 combobox1.add item var4 I would like to add them across in Col 1, Col 2, Col 3 and Col 4. I haven't used combo boxes before and am struggling with this one. Thanks for the help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox with columns
If you build an array and then assign it to the combobox list property, it
should populate the columns, e.g., lbItem (1,1) = "Name" 'Row 1, Column 1 lbItem (1,2) = "Company" 'Row 1, Column 2 lbItem (2,1) = "Bill" 'Row 2, Column 1 lbItem (2,2) = "MS" 'Row 2, Column 2 combobox1.list = lbitem() http://HelpExcel.com "JT" wrote: I have a combo box on my form with 12 columns. The items are added down in the first column when I use the following code: combobox1.add item var1 combobox1.add item var2 combobox1.add item var3 combobox1.add item var4 I would like to add them across in Col 1, Col 2, Col 3 and Col 4. I haven't used combo boxes before and am struggling with this one. Thanks for the help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox with columns
if its a range
combobox1.List = worksheets("Sheet1") _ .Range("A2").Resize(20,12).Value -- Regards, Tom Ogilvy "JT" wrote in message ... I have a combo box on my form with 12 columns. The items are added down in the first column when I use the following code: combobox1.add item var1 combobox1.add item var2 combobox1.add item var3 combobox1.add item var4 I would like to add them across in Col 1, Col 2, Col 3 and Col 4. I haven't used combo boxes before and am struggling with this one. Thanks for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
columns Widths for ComboBox | Excel Discussion (Misc queries) | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
OFFSET for multiple columns & combobox format | Charts and Charting in Excel | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
Populating combobox from another combobox | Excel Programming |