+ Reply to Thread
Results 1 to 8 of 8

How Do I create a Form that Mimics the Attached User Form

  1. #1
    Forum Contributor
    Join Date
    09-19-2004
    Location
    Canada
    Posts
    408

    Question How Do I create a Form that Mimics the Attached User Form

    Hi all,

    I have created the attached user form (exactly as the actual form should look) but I can't figure out how to get the user to use it and then print out a copy. Any help?

    Thank you,
    Gos-C
    Attached Files Attached Files
    Using Excel 2010 & Windows 10
    "It is better to be prepared for an opportunity and not have one than to have an opportunity and not be prepared."

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Do you mean you want to replicate the form on a worksheet?

    Then populate the ' form' on the worksheet with the data from the userform and print it.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    09-19-2004
    Location
    Canada
    Posts
    408

    Re: How Do I create a Form that Mimics the Attached User Form

    That's right, Norie. I didn't realize that the user won't be able to print the userform.

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How Do I create a Form that Mimics the Attached User Form

    Hi Gos-C

    I can show you how to Print the UserForm...I can't tell you how to get the Users to use it. The UserForm is too intimidating.

    Click the Option to print it out.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  5. #5
    Forum Contributor
    Join Date
    09-19-2004
    Location
    Canada
    Posts
    408

    Re: How Do I create a Form that Mimics the Attached User Form

    Hi jaslake,

    No, the printout of the userform won't work. It has to be an "actual form" (that will be faxed). Nevertheless, I appreciate your assistance.

    Gos-C

  6. #6
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How Do I create a Form that Mimics the Attached User Form

    Hi Gos-C

    I don't know what this means
    It has to be an "actual form" (that will be faxed).
    The Code prints out your "actual form" which then can be faxed.

    If this doesn't work for you it doesn't work. Perhaps Norie can help you.

  7. #7
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: How Do I create a Form that Mimics the Attached User Form

    Gos-C

    Did you actually get the design for the userform from a paper form?

    I've seen paper forms like this, with things like single boxes for each digit of a date/telephone no.

    That doesn't really work with userforms, try entering a date or take a look at the attached image and you'll see what I mean.
    Attached Images Attached Images

  8. #8
    Forum Contributor
    Join Date
    09-19-2004
    Location
    Canada
    Posts
    408

    Re: How Do I create a Form that Mimics the Attached User Form

    Hi Norie,

    Yes, I got the design of the userform from a paper form, but the single boxes for each digit are not necessary.

    Jaslake, I mean that I don't want a picture of the userform.

    Gos-C

+ 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] User Form - Hyperlink Button within a Form, to create a Link on a Designated Cell
    By Sinalk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 07:29 AM
  2. [SOLVED] User Form to execute search and return all values to the user form for editing
    By allwrighty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2013, 10:40 PM
  3. Help with VBA Commands on all buttons to active attached User form
    By virgome in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2013, 10:43 AM
  4. Filling form fields via worksheet dropdowns, user update via form, change form color
    By Demosthenes&Locke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2010, 08:58 AM
  5. [SOLVED] form in excel to be attached to the emails address in the form upon sumission
    By Abdulkader Bhanpurawala via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-10-2005, 06:05 AM

Tags for this Thread

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