List and ComboBoxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Torey - 07 Sep 2005 23:10 GMT

I went through the basic UserForm tutorial on the Word MVP site. (Extremely
helpful!!). I wanted to use a listbox to have users chose 'Mr., Mrs., Ms' in
the form. I don't know about arrays and all that. What is the simplest way
to populate the list with these unchanging choices.

Thanks,
Torey

Reply to this Message

Jonathan West - 08 Sep 2005 00:44 GMT

>I went through the basic UserForm tutorial on the Word MVP site. (Extremely
>helpful!!). I wanted to use a listbox to have users chose 'Mr., Mrs., Ms'
>in the form. I don't know about arrays and all that. What is the simplest
>way to populate the list with these unchanging choices.

Put the following into the UserForm_Initialize event of your UserForm

Private Sub UserForm_Initialize()
ListBox1.List = Array("Mr.", "Mrs.", "Ms.", "Dr.")
End Sub

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Reply to this Message

Torey - 08 Sep 2005 02:59 GMT

Thank You!!

>>I went through the basic UserForm tutorial on the Word MVP site.
>>(Extremely helpful!!). I wanted to use a listbox to have users chose 'Mr.,
[quoted text clipped - 6 lines]
> ListBox1.List = Array("Mr.", "Mrs.", "Ms.", "Dr.")
> End Sub

Reply to this Message