View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
michaelberrier
 
Posts: n/a
Default Userform Initialize & combo box values

I have the following code for populating a combobox with numbers 1-10.
Is there a way to change it to display letters instead of numbers?

Private Sub UserForm_Initialize()
Dim iCtr As Long
For iCtr = 1 To 10
Me.ComboBox1.AddItem iCtr
Next iCtr
End Sub

Thanks to all.