PDA

View Full Version : Solved: Combo boxes in Word



newk
11-22-2004, 08:40 AM
Thanks to vba express I have managed to muddle together this automated fax.

I now need a little help making a combo box work. Do I need to create an excel or access table and import the data? I would much rather keep the data with the document and change when it requires it.

I would like to add these names in the combo box:

Name,_____________Tel,____________Fax,
Charlotte Wise,_ 01737 221654,____01737 221652
Lucy Glaver,____01737 221655,____01737 221652
Molly Seeker,___01737 221656,____01737 221653

The name I would like to appear under 'Regards' and in the text document at bookmark 'CollectionsRep'. The number I would like to be looked up, so if Lucy is selected it will automatically be her phone and fax number that will be placed in the 'CollectionsRepPhoneFaxNumber' bookmark without being typed in. Is this Possible? :mkay

mdmackillop
11-22-2004, 01:25 PM
A couple of arrays added to contain the data, and a change to the combobox setup. I'd no time to sort out the fax number, but you'll see how its done.
MD

newk
12-21-2004, 05:52 AM
MD,

That's fantastic, it all works great and the best part I think I've learnt how to do combo boxes.

I am really sorry this response is so late I was reviewing my posts and noticed I never thanked you, SO THANK YOU, you are a life saver.

newk