Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 09-26-2016, 09:35 PM
oxicottin oxicottin is offline Add VBA to a button in Word Windows 7 32bit Add VBA to a button in Word Office 2007
Novice
Add VBA to a button in Word
 
Join Date: Dec 2012
Posts: 5
oxicottin is on a distinguished road
Default

I'm on a work PC so I cant register to look at the .zip nor can I download any third party add-ons. I'm looking for some VBA that if I entered Sundays date (9/25/16) in cell F:1 and clicked the print button Named (PrintWeek), it would print the page and automatically change that date to the following Sunday which is 10/2/16 and I can print it again and it would change the date to the next Sunday and so on.

Something like:

Private Sub PrintWeek_Click()
'ActiveDocument.Range("F:1") Something Here to change date
ActiveDocument.PrintOut Range:=wdPrintCurrentPage
End Sub

Thanks,
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Add VBA to a button in Word Automatize word button. Eduardo Care Word 1 08-13-2015 06:01 PM
Calculation Button in Word tables Barry Bolton Word Tables 3 02-14-2014 06:01 PM
Add VBA to a button in Word Timestamp Button Word Victora Word VBA 1 12-29-2012 08:47 AM
Add VBA to a button in Word Clickable button in word ndjustin20 Word VBA 1 02-08-2012 02:50 PM
MS Word form - email button floydwood Word VBA 0 05-10-2009 04:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 AM.


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