+ Reply to Thread
Results 1 to 3 of 3

Printout Scrollable Userform

  1. #1
    Forum Contributor
    Join Date
    05-28-2020
    Location
    Poland
    MS-Off Ver
    O365,
    Posts
    120

    Printout Scrollable Userform

    Good morning,

    I have a Userform (Height 800, Width 625) which is scrollable and has a ScrollHeigth of 2500.

    Is there a possibility, to printout the form with it's 4 images within the form and additionally to
    print those 4 images onto 1 sheet?

    Using Printform is printing the first image which is about the size of one sheet and the rest is
    being left out.

    Is there a way, so I can fit the 4 images onto one page and how do I tell Printform, that there is
    more to print?

    Thank you very much for the help and support

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,303

    Re: Printout Scrollable Userform

    The attached may be a starting point for you, I have attached a print routine to one of my apps, shuffle the cards, then deal them, then press 'PRINT'.
    I am not to familiar with all the API calls, you will have to adjust the code settings to achieve your requirements.
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  3. #3
    Forum Contributor
    Join Date
    05-28-2020
    Location
    Poland
    MS-Off Ver
    O365,
    Posts
    120

    Re: Printout Scrollable Userform

    Hello torachan,

    Thanx a lot for helping me out here. I will have a look into it. In the worst case, I have also a plan B, might not as good but as a workaround.

    Appreciate your help!

+ 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. Scrollable table possible?
    By tml2424 in forum PowerPoint Formatting & General
    Replies: 0
    Last Post: 12-10-2021, 01:53 PM
  2. How to make a section scrollable
    By cantras in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-14-2020, 03:00 PM
  3. [SOLVED] How to construct a scrollable pane within a UserForm
    By PDBartlett in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-29-2014, 09:42 AM
  4. [SOLVED] Printout via Listboxes on UserForm
    By ScotyB in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-21-2012, 09:21 PM
  5. Scrollable Limits
    By bkeavney in forum Excel General
    Replies: 1
    Last Post: 12-03-2009, 07:26 PM
  6. Printout sheets with a userform
    By fragher75 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2006, 04:30 PM
  7. [SOLVED] Scrollable Frame
    By James W. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2005, 06:06 PM

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