+ Reply to Thread
Results 1 to 6 of 6

Screenshot and print a userform

  1. #1
    Registered User
    Join Date
    07-16-2018
    Location
    Geneva Switzerland
    MS-Off Ver
    Excel 2016
    Posts
    7

    Screenshot and print a userform

    Hello everybody,
    This is my first question.
    I would like to get images of a series of userforms and to paste each of them into a new worksheet in the active workbook, only through VBA code (no Commandbutton). To trigger the screen capture I added a extra textbox in my userform with a value which changes for each USF and is processed through a
    Please Login or Register  to view this content.
    procedure.
    My problem is that if I write
    Please Login or Register  to view this content.
    without adding a zero the execution of the code stops when the USF pops up and if I add a zero a got a capture of my VBA code !
    What do I wrong ?
    Thank you in advance for any suggestion.
    regards
    Pierre

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Screenshot and print a userform

    You haven't supplied the code that is giving you problems

  3. #3
    Registered User
    Join Date
    07-16-2018
    Location
    Geneva Switzerland
    MS-Off Ver
    Excel 2016
    Posts
    7

    Re: Screenshot and print a userform

    Hi davesexcel and many thanks,
    I avoid it because there is a lot of code, sorry.

    There is a plenty of French words. Don't hesitate to ask for explanations.
    C_Fiche_indiv is my USF's name

    Here's my code:

    In a standard module:
    Please Login or Register  to view this content.
    In the USF module:
    Please Login or Register  to view this content.
    Many thanks in advance for any help.
    Best regards
    Pierre
    Last edited by pierruel; 07-16-2018 at 10:19 PM. Reason: More clarity.

  4. #4
    Registered User
    Join Date
    07-16-2018
    Location
    Geneva Switzerland
    MS-Off Ver
    Excel 2016
    Posts
    7

    Re: Screenshot and print a userform

    Good evening,
    Additional information.
    The code extract posted recently (Screenshot and print a userform) is part of the following
    project:
    1) To build a list of music composers mentioning the contribution of each of them to the
    evolution of the musical language (e.g. Schoenberg with the dodecaphonic language),
    2) add to each composer, if available, (the list of) his teachers or former composers which
    influenced him with their contribution,
    3) build a kind of a genealogical tree going from teachers to pupils and marking the way the
    various features of the musical language "followed" down from the origins to todays' music
    composers.
    An intermediate step is the building of a collection of individual cards (like in a Kardex),
    and it's the reason why I want to print userforms, each userform representing one composer
    with first/last name, year of birth/death, land of activity, list of "teachers" (in a wide
    sense) and of pupils, contribution to the musical evolution and/or inherited musical features
    from predecessors.
    Beginning around 1900 I'll have about 450 to 500 composers in my database and it's why I
    need printing individual cards automatically instead of clicking 450 or 500 times on a button.
    Many thanks for your help.
    Best regards
    Pierre

  5. #5
    Registered User
    Join Date
    07-16-2018
    Location
    Geneva Switzerland
    MS-Off Ver
    Excel 2016
    Posts
    7

    Re: Screenshot and print a userform

    Hi !
    Bump no response.
    Greetings
    Pierruel

  6. #6
    Registered User
    Join Date
    07-16-2018
    Location
    Geneva Switzerland
    MS-Off Ver
    Excel 2016
    Posts
    7

    Re: Screenshot and print a userform

    Good evening,
    Question asked on July 16th, no answer on July 22nd, I'll be asking elsewhere on the web and say thanks and good bye.
    P.

+ 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. Excel VBA Screenshot Cell range to Userform picture based on combobox selection
    By andytesting in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-27-2017, 04:02 AM
  2. Find a word "screenshot" and print value "yes" in adjacent Column
    By prat123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2015, 03:04 PM
  3. [SOLVED] Paste Excel Userform Screenshot into Word document
    By t0mps in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2014, 07:10 AM
  4. Screenshot Userform and send it as an attachment through outlook
    By gsscguna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2014, 07:24 AM
  5. Need to send a screenshot of active userform in e-mail body
    By rsyadavsoft41 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-24-2013, 03:08 AM
  6. [SOLVED] Click Print on Userform and Print a file
    By stojko89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2011, 07:57 AM
  7. Print Button to print UserForm for multi-sheet
    By smartcard in forum Excel General
    Replies: 12
    Last Post: 04-29-2010, 07:47 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