Consulting

Results 1 to 3 of 3

Thread: Solved: Combo boxes in Word

  1. #1
    VBAX Regular
    Joined
    Nov 2004
    Posts
    74
    Location

    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?

  2. #2
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    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'

  3. #3
    VBAX Regular
    Joined
    Nov 2004
    Posts
    74
    Location
    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
  •