Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-07-2020, 04:25 AM
dogbural dogbural is offline change header, footer information dependent on selection in drop down list Windows 8 change header, footer information dependent on selection in drop down list Office 2013
Novice
change header, footer information dependent on selection in drop down list
 
Join Date: May 2020
Posts: 1
dogbural is on a distinguished road
Default change header, footer information dependent on selection in drop down list

Hi,

I am wondering if it is possible to automatically change the header image (ship or airplane), footer document control name (document control: ship or airplane), and address (ship Ocean or airplane sky) by selection of drop down list.



Attached is an example.

Under Company, we have two options, either Ship or Airplane

Please advise VBA can do this.

Regards,
MK
Attached Files
File Type: docx Example.docx (31.1 KB, 9 views)
Reply With Quote
  #2  
Old 06-07-2020, 08:08 AM
gmaxey gmaxey is offline change header, footer information dependent on selection in drop down list Windows 10 change header, footer information dependent on selection in drop down list Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,428
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

Yes, its possible. See the ongoing discussion in https://www.msofficeforums.com/word-...own-lists.html
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #3  
Old 06-07-2020, 04:12 PM
macropod's Avatar
macropod macropod is offline change header, footer information dependent on selection in drop down list Windows 7 64bit change header, footer information dependent on selection in drop down list Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See, for example:
https://www.msofficeforums.com/word-...html#post46903
and, for different elements from a selected item to be output to different content controls, see:
https://www.msofficeforums.com/word-...tml#post120392
FWIW, changing the header/footer content doesn't even require a macro - just one or more STYLEREF fields in conjunction with IF tests.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
change header, footer information dependent on selection in drop down list Autofill a field based on drop down list selection lascough20 Word 2 09-21-2018 02:24 AM
dynamic dependent drop down list based on input with reference to a two column table jwan142 Excel 4 05-23-2018 08:15 AM
Help with Vlookup in a Dependent drop down list angelmr Excel 0 11-29-2016 09:25 AM
Change information on header for each page? lurchybold Word 10 01-24-2014 08:08 AM
change header, footer information dependent on selection in drop down list Change cell color when selection is made from a drop down list fedcco Excel 12 08-28-2012 10:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft