If you only have a small number of entries to add, I'd use the
UserForm_initialize event.

Option Explicit
Private Sub UserForm_Initialize()
With Me.ComboBox1
.AddItem "Item1"
.AddItem "Item2"
.AddItem "Item3"
End With
End Sub

Debra Dalgleish has some instructions he
http://contextures.com/xlUserForm01.html
http://contextures.com/xlUserForm02.html
and
http://contextures.com/xlVideos05.html#UserForm01
http://contextures.com/xlVideos015html#UserForm01

John Calder wrote:

Hi

I run Excel 2K

I have opened the VB editor and inserted a "form".

I have added a combobox to the form

What I need to know is how do I populate the combobox with lets say 5 items:-

Example

Item1
Item2
Item3
Item4
Item5

and make it run in the spreadsheet.

Thanks

John

--

Dave Peterson