Consulting

Results 1 to 3 of 3

Thread: Copy the selected drop down text to the bottom of page +

  1. #1

    Question Copy the selected drop down text to the bottom of page +

    Hello,I have a drop down box at the top of my page "Dropdown1" where you select final or draft.I would like whatever is selected in this box to copy to a text box at the bottom of the page and, if there are subsequent pages, to the top and bottom of them.I have tried this by putting the dropdown in a cell and 'repeating as a header' but it has not worked.I would appreciate any help to resolve this matter.Thank youJose

  2. #2
    Microsoft Word MVP 2003-2009 VBAX Guru gmaxey's Avatar
    Joined
    Sep 2005
    Posts
    3,340
    Location
    What kind of dropdown? ActiveX? Probably a mistake.

    If you are using Word 2007 or higher an easy way is to put a dropdown content control in the header. Map it to a custom XML part using the InstaMap method of my: http://gregmaxey.mvps.org/word_tip_p...rol_tools.html

    Then copy and paste the mapped CC to the footer.
    Greg

    Visit my website: http://gregmaxey.com

  3. #3
    VBAX Mentor
    Joined
    Feb 2015
    Posts
    395
    Location

    Linking TextBox to Cell, Cell Value in header

    http://www.vbaexpress.com/kb/getarticle.php?kb_id=739 - Shows three different way to put a cell value in a header
    Also to put cell value in text box is reallly quick
    1 Select textbox
    2 Click on formula bar and type in =A1 (or whichever cell your ListBox is in)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •