Vba code to return a value

[eklarsen]

I want to populate a Listbox with the value of a cell of a worksheet in the the same workbook.
this is what I have

Sub Populateselldays()
lb04selldays = Sheets("selling")("c2").Value
End Sub

"Selling" is the name of the worksheet and the value I want is in c2.
"lb04selldays" is the name of the list box

I call the sub on initialize but it gives me errors.
Any thought on how this can be done?

[Leith Ross]

Hello EKLarsen,

Make these changes and the code will work.

Sub Populateselldays()
lb04selldays.AddItem Sheets("selling").Range("C2").Value
End Sub

Best wishes,
Leith Ross

[eklarsen]

It worked perfectly thank you.
Sorry for being such a newbie