Populating Combo/List boxes

E

Erica

I have never used VBA or VB before, but would like to
insert drop down list boxes into a transmittal document so
that users can choose by which method the transmittal is
sent (ie. fax, courier, mail, etc.) for each recipient.

I've only gotten as far as inserting the control, but can
not figure out how to populate the list with the options
(told you I was new). I feel like it shouldn't be so
difficult - is it?

This form will be used as a template, are there any other
issues I need to be aware of in regards to this?

Any help would be much appreciated.

Thanks,

Erica
..
 
P

Perry

Why don't you use a DropDown list from the Forms toolbar?
This is easily populated without having to use VBA.

Forms toolbar: Word GUI menu
View | Toolbars => Forms
Choose the DropDown from the toolbar, draw it on the document
and rightclick on the dropdown to bring up the properties window.
The rest will be self explanatory

Kindly repost if you still want to make use of the
Combo/Listbox off the Toolset (ActiveX) toolbar

Krgrds,
Perry
 
G

Guest

Firstly, thanks very much for the response.

I've had a look at using the forms toolbar (and learned
some cool things about creating forms), but I still have a
problem with inserting a drop-box this way.

As I mentioned, I want to use the drop-box to allow people
to choose the by which method the document will be sent
(fax, courier, etc.). There are often multiple people who
will recieve the document, but there is never a set number
(ie. sometimes it's sent to one person, sometimes three,
sometimes ten, or any other number in between). Therefore
the form user needs to be able to add or delete address
lines as needed. I would like to be able to choose the
send method for each reciever (ie. insert a drop-box on
each address line). If I use the form toolbar, then lock
the form, the users will not be able to add or delete
address lines.

Clear as mud? If I'm going about this the wrong way I'm
open to any suggestions. Otherwise, I thought the whole
form thing was very neat, and I'll definately use it in
the future.

Thanks again.
 
G

Guest

Freakin' awesome! That works great! Exactly what I was
looking for! Thanks so much Jay, and everyone else who
helped me out, I've learned a lot.

Have a great day.

Erica
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top