MrExcel Publishing
Your One Stop for Excel Tips & Solutions

setting up userform combobox?


Posted by Ben on April 20, 2001 10:49 AM

Could anyone please tell me how to set up a Combobox in a user form, so that the user can select either Mr, Mrs and Ms.

Thanks


Posted by Dax on April 20, 2001 11:00 AM

You or me Dave?

Posted by Dave Hawley on April 20, 2001 11:07 AM

Re: You or me Dave? Why not both of us hey :o)


Hi Ben

If you only want 3 choices I would use:

Private Sub UserForm_Initialize()
With ComboBox1
.AddItem ("Mr")
.AddItem ("Mrs")
.AddItem ("Ms")
End With
End Sub

But if you want a large list of choices put the entries in say range A1:A100 and set the RowSource Properties window to: A1:A100

Dave

OzGrid Business Applications