Thread: Listbox Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete Pete is offline
external usenet poster
 
Posts: 193
Default Listbox Help

I am new to the whole VBA world. But I have figured out how to populate a
list box in a Userform with options, however I can not seam to figure out how
to take the selected option and populate it in one of my sheets to keep track
of the seletions.

Here is what I have

Sub Question1()

Dim MyArray As Variant
Dim Ctr As Integer
MyArray = Array("Apples", "Oranges", "Peaches", "Bananas", "Pineapples")

For Ctr = LBound(MyArray) To UBound(MyArray)
UserForm11.ListBox1.AddItem MyArray(Ctr)
Next
UserForm11.Show

End Sub

If the user selects "Apples", I want "Apples" to populate in cell A1 in
sheet 1
TIA
--
Pete