list box (simple question)

[kathryn]

Hi,

I've been trying to add items to my list box, using either additem or list, but neither is working:

Private Sub ListBox1_Click()
ListBox1.AddItem = (1,"Consumption")

End Sub

Am I missing something?

Thank you. ray:

 

[Jotoya]

Hi,

I've been trying to add items to my list box, using either additem or list, but neither is working:

Private Sub ListBox1_Click()
ListBox1.AddItem = (1,"Consumption")

End Sub

Am I missing something?

Thank you. ray:

Hi kathryn and welcome!

It depends do you have your ListBox in a UserForm or on a sheet?

If you have the ListBox in UserForm then try this:

Private Sub UserForm_Initialize()

' Use the UserForm Initialize event to populate your Listbox.

ListBox1.AddItem "Consumption"

End sub

Hope this helps.