LISTBOX COLUMNHEADS WITHOUT TO USING ROWSOURCE???

galileogali

Well-known Member
Joined
Oct 14, 2005
Messages
748
I want to populate a ListBox by means of Method AddItem and List. How to load the Column Heads?


Can be used the RowsourceType Property?
How?


GALILEOGALI
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Column heads for List/Combo box can be only added when you specify Rowsource. (don't know about 2007)
 
Upvote 0
jindon:
Thanks you.
The negative answers or of "nonexistence" sentences, are always difficult to obtain.
Thanks
 
Upvote 0
Sub itemstocombobox()
Dim myColcnt As Integer
Dim myListItem

myColcnt = Range("IV1").End(xlToLeft).Column

ComboBox1.clear

For i = 1 To myColcnt

ComboBox1.AddItem Range(Cells(1, i), Cells(1, i)).Value

Next

End Sub

or similar
 
Upvote 0
jindon:
Thanks you.
The negative answers or of "nonexistence" sentences, are always difficult to obtain.
Thanks
yes !
I saw this one yesterday, despite knowing it isn't possible, tested and retested again and still afraid to post my "no, this is not possible"

bravo for your courage, jindon :biggrin:

kind regards,
Erik
 
Upvote 0
What I guess is its Index.

Lower bound set to -1, therefore it needs to have something on the top of the list.

Whereas Additem, List(), Column() property can not have...

This is only my guess...
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,210
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top