How should I make a ListBox in Excel into a Date Sorce?

Question

How should I make a List Box in Excel into a Date Sorce?

Answer 1

aaa long time... and easy answer using code write up... hmm
ok learn

 Dim x&, y&  
 For x = 1 To ListBox1.ColumnCount  
       For y = 1 To ListBox1.ListCount  
            If x = 1 Then Cells(y, 2) = ListBox1.List(y - 1, x - 1)  
            If x = 2 Then Cells(y, 1) = ListBox1.List(y - 1, x - 1)  
       Next  
 Next  

X variable I using for columns, then switch that is a easy job to do. Its done.

So exercise for you now - you must read about that and make it.
If you had a more than 2 columns in control, learn about back loop without condition, to switch it opposite count. Do you?

Answer 2

I am very new with VBA.. I would like to use a List Box for a data source. Is this possible?

Answer 3

@Charles Qi_MSFT

Answer 4

I guess.
you can see list box using in worksheet as object ActiveX

or you can use the same in VBA Form as control

Answer 5

Hi, @Oskar Shon

Please see snipping below. I am trying to push data from a Listbox to a spreadsheet.