-
Solved: Combo boxes in Word
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?
-
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
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules