+ Reply to Thread
Results 1 to 5 of 5

Printing multi layer multipage userforms

  1. #1
    Registered User
    Join Date
    05-17-2013
    Location
    Taunton, Somerset
    MS-Off Ver
    Excel 2010
    Posts
    12

    Question Printing multi layer multipage userforms

    Hi all

    I have got an excel userform with multipages within multipages. When I print all I get is the top level of pages, nothing that is contained within those.

    Can anyone help as I've been trawling the net and still can't find anything that solves my problem.

    Thanks in advance.

    Matt

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Printing multi layer multipage userforms

    I've done it in the past as a report to print.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

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

    Re: Printing multi layer multipage userforms

    Userforms aren't realy designed for printing.

    Couldn't you transfer the data to a worksheet and print that?
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    05-17-2013
    Location
    Taunton, Somerset
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Printing multi layer multipage userforms

    Thanks for the replys.

    I have carried on trying but not succeeded some am coming to the conclusion that I'll have to set up another worksheet to print from. Was just hoping that the userform method would work.

    Thanks again.

  5. #5
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Printing multi layer multipage userforms

    You'll get it to print, but will start to look awful set up a hidden sheet and pump the values in, with some formatting you could make it look like the userform.

+ 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. Multi-Layer Product-IF Formula
    By Sleeper in forum Excel General
    Replies: 0
    Last Post: 05-16-2011, 05:12 PM
  2. add a second layer to multipage control on userform
    By smokebreak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2011, 05:14 PM
  3. Multi-layer excel spreadsheets
    By AggieBouse06 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 07:05 AM
  4. [SOLVED] Multi-layer excel spreadsheets
    By AggieBouse06 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 06:05 AM
  5. Multi-layer excel spreadsheets
    By AggieBouse06 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2005, 02:05 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