Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2019, 06:55 AM
alecambo alecambo is offline Generating coversheets using inputboxes Windows 10 Generating coversheets using inputboxes Office 2019
Novice
Generating coversheets using inputboxes
 
Join Date: Apr 2019
Posts: 5
alecambo is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
It writes ABC and 123 because Greg hard coded that into the template code rather than the strName and strNum from the userform, no doubt while testing if his code worked to populate the controls in the loop (the incrementing date being the important bit of the code), and then forgot to replace the fixed texts with the string variables. It's easily done.

Code:
      .ContentControls(1).Range.Text = "ABC"
      .ContentControls(2).Range.Text = "123"
The date format is set in the date content control properties, but once changed the autotext entry also has to be updated as that contains a copy of the template body with the three content controls.

See attached
Thanks gmayor.
I forgot to add that between the store name and date I need to have a day of the week for staff (i.e. "Tuesday")

I would assume that this would be inserted as an aforementioned input - ".ContentControlsi.ContentControls(1).Range.Te xt = sDayName", but it doesn't seem to work. Is there something I'm missing here?

Thanks again for your help
Reply With Quote
Reply

Tags
inputbox



Similar Threads
Thread Thread Starter Forum Replies Last Post
Generating coversheets using inputboxes generating a calendar jimmy2016 Mail Merge 2 09-28-2016 11:09 PM
Generating coversheets using inputboxes Generating a Letter Shanna86 Word 9 09-29-2015 09:11 PM
Generating coversheets using inputboxes generating a number in Word John P Word 1 05-31-2012 10:29 PM
Generating Buy/Sell signals accordingly... babapusy Excel 0 04-14-2012 10:11 AM
MS Word 2003 – Generating a ToC krazykasper Word 1 04-29-2009 02:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 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