+ Reply to Thread
Results 1 to 8 of 8

How to create simple Invoice template with content control

  1. #1
    Registered User
    Join Date
    04-22-2020
    Location
    Amsterdam
    MS-Off Ver
    365
    Posts
    86

    How to create simple Invoice template with content control

    Hello,

    I am trying to build an Invoice template. I have created an standard Word template and I want to edit it to my demandings.

    I have some questions:
    1. What kind of content control is used in standard Word templates? When I place my cursor at the text in the table (for example "Product description"), it turns gray shaded. When I click at the properties button at the developer Ribbon, I can't edit the text but only the Title and Tag?

    2. How can I edit the CURRENCY in this form? I want to have it in Euros (€).

    3. Can I link this data into a kind of form? In the end I want to have a pop-up box which give me the options to fill in the Invoice. For example having 20 apples as PRODUCT the form should asked:
    - Product Quantity: [INPUT]
    - Product Description: [INPUT]
    - Price per product: [INPUT]
    The rest of the Invoice will be entered automatically by calculation.

    4. Should Excel been used in this case? Or can this been done in Word?


    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to create simple Invoice template with content control

    I don't have any difficulty clicking a Product Description item and changing it.

    Just copy a Euro symbol and paste it in place of the $ character

    Personally I'd have used Excel to design the template. You have a lot more control over how stuff is presented and what should happen given different events or data entries. You may find one of the many standard Excel templates would meet your requirements and if not all you need could be easily adapted to add more functionality.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-22-2020
    Location
    Amsterdam
    MS-Off Ver
    365
    Posts
    86

    Re: How to create simple Invoice template with content control

    Quote Originally Posted by Richard Buttrey View Post
    I don't have any difficulty clicking a Product Description item and changing it.

    Just copy a Euro symbol and paste it in place of the $ character

    Personally I'd have used Excel to design the template. You have a lot more control over how stuff is presented and what should happen given different events or data entries. You may find one of the many standard Excel templates would meet your requirements and if not all you need could be easily adapted to add more functionality.
    Hi Richard,

    I don't want to change it by clicking on it and change it. I want to change it with an INPUT from a form.

    As well for the Euro symbol, I want to know how the template is build. I want to improve my skills in Word and not just doing something because it works. Could you explain some more about your design in Excel? I am not an expert in Microsoft Office yet.

    Thanks

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to create simple Invoice template with content control

    Have you looked at the numerous Excel Invoice Templates available from within Excel, I can see 32 on the first page. Googling Excel Invoice Templates will turn up dozens of others

    The thing to do is identify one that is close to what you want and then adapt it. Once you've done that upload it here with comments about how you want to automate and use it.

  5. #5
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: How to create simple Invoice template with content control

    Quote Originally Posted by luukos97 View Post
    1. What kind of content control is used in standard Word templates?
    None. Your document is full of plain text content controls, however - often where it is not appropriate to have them.
    Quote Originally Posted by luukos97 View Post
    When I click at the properties button at the developer Ribbon, I can't edit the text but only the Title and Tag?
    That's because the prompt is meant to be overtyped (not in Developer mode). Moreover, because some or all of the content controls have the 'Remove content control when contents are edited' property set, they'll be deleted when you do that.
    Quote Originally Posted by luukos97 View Post
    2. How can I edit the CURRENCY in this form? I want to have it in Euros (€).
    It already shows Euros for the 'Unit Price' column. Simply copy/paste the € symbols over the $ symbols. Word has no 'currency' format.
    Quote Originally Posted by luukos97 View Post
    3. Can I link this data into a kind of form?
    Yes, but you'd need to provide a lot more detail.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  6. #6
    Registered User
    Join Date
    04-22-2020
    Location
    Amsterdam
    MS-Off Ver
    365
    Posts
    86

    Re: How to create simple Invoice template with content control

    Thanks for the answers

    I think the question of mine isn't described very clear.

    I have added a diagram where I try to visualize what I mean. In this you can see the input form should have some variables which needs to be filled. When the data is filled in this form, the data needs to be transferred to the Excel filled to the desired cell.

    I have added as well the Invoice template which I found at the Excel templates, thanks Richard.
    Attached Files Attached Files

  7. #7
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to create simple Invoice template with content control

    Do you have a list of products and prices? If so please supply a list

    What's the maximum number of line items you'd want on an invoice?

    If it's limited to say a dozen then it would be simpler than if the numberv is variabled and additional lines would need to spill over to a 2nd/3rd page

    There's two distinct ways you could approach this.
    As it's laid out you could simply type the customer name and address details directly into the Invoice in the appropriate place and then select product line items from drop downs.

    The other way is to create a proper normalised two dimensions database table where columns contain all the field items and every row is a unique line item.
    After line items have been added you could then have a macro attached to a button which would prompt you for a Customer Invoice Reference, and then the macro would extract the relevant items from the database and populate the Invoice. Using this approach you'd have a permanent record of all your invoices

  8. #8
    Registered User
    Join Date
    04-22-2020
    Location
    Amsterdam
    MS-Off Ver
    365
    Posts
    86

    Re: How to create simple Invoice template with content control

    Do you have a list of products and prices? If so please supply a list
    Yes I have provide it in the appendix of this reply.

    What's the maximum number of line items you'd want on an invoice?
    This should be variable, it is often I have long list of items which should be attached at the Invoice.

    As addition, I think I should have a look at the formatting of the Invoice. For example: The description is filled with a lot of text, the Excel format should format itself with Wrap Text or so. What do you think about this formatting? Another way maybe is to give the input form a max input of characters.

    Sorry for the late response, I got some busy times with work at the moment...
    Attached Files Attached Files

+ 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. VBA Code to create new excel files based on content of cell from a template file
    By alan.sluder in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-30-2018, 04:33 AM
  2. vba code to copy the values from database into invoice template and create new workbooks
    By anishkumarvs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2015, 02:48 AM
  3. Replies: 1
    Last Post: 04-02-2014, 09:46 PM
  4. How to Create DYNAMIC Invoice Template
    By benb505 in forum Excel General
    Replies: 7
    Last Post: 07-30-2013, 01:20 PM
  5. create new workbook invoice from template
    By stuartgentle in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2013, 10:33 PM
  6. create new simple stock card / control
    By SelinaT in forum Excel General
    Replies: 0
    Last Post: 09-22-2010, 11:34 PM
  7. Replies: 1
    Last Post: 05-17-2005, 02:06 PM

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