+ Reply to Thread
Results 1 to 3 of 3

Using VBA to enter given text and date to footer

  1. #1
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    641

    Using VBA to enter given text and date to footer

    I'm trying to use VBA to enter some given text followed by today's date into the footer of my Word page.

    The VBA would open the footer , enter 'Today's date is - ' and then the date in dddd, dd MMMM yyyy format. It would then close the footer.

    Can someone suggest some code to satisfy this?

    Grateful for any advice.

    Last edited by CDandVinyl; 08-08-2021 at 11:38 AM.
    Using Excel , Word and Access 2003 - For the whole of 2024

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,701

    Re: Using VBA to enter given text and date

    Headers and footers are by section. If you just have one section in your document use this:

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    641

    Re: Using VBA to enter given text and date

    That's it - perfect! Many thanks!

    Last edited by CDandVinyl; 08-08-2021 at 11:39 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Enter date to text box in user form
    By ericgr8 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2019, 01:27 AM
  2. [SOLVED] If cell meets date requirement enter 1, if not enter 0, if blank don't enter anything.
    By billrogers184 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-11-2017, 02:04 PM
  3. Force a user to enter a date instead of text
    By Crispy85 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-16-2017, 05:43 AM
  4. [SOLVED] Prefill text box in userform with today's date but allow user to enter unique date
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-02-2014, 09:17 AM
  5. [SOLVED] Using A Specified Date to Select a Cell and enter a value from a text box in vba
    By MDLV1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-25-2013, 02:24 PM
  6. [SOLVED] I need a date stamp that doesn't change when you enter text
    By Eric Hersey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-09-2006, 01:45 PM
  7. Enter Text or Date on Multiple Sheets
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2005, 04:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1