Results 1 to 4 of 4

Multi page userform

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-28-2006
    Posts
    122

    Multi page userform

    Hi, I have a problem with a userform that for some reason I cannot seem to work out.

    The basic problem is as follows:-

    I have a "data sheet" which contains complete order details, complete invoice details and basic Customer details. a separate sheet contains complete customer details.

    what i am trying to do is create a multipage user form (no reason for this except i think its a good idea! so if there is a better way please feel free to comment) as follows.

    on page 1 - create a report of All invoices unpaid (from the orderdata sheet)

    on page 2 - create a report of All invoices unpaid AND overdue (from the orderdata sheet)

    on page 3 - create a report of customer names (using the overdue invoice list from the orderdata sheet which has basic customer information + the customer contact details from the CustomerData sheet)

    So what i am trying to do is search the relevant sheets for the relevant values, (which i think i have got worked out) and the for EVERY row that contains a match transfer the information to the particular multipage. I have added scroll bars to enable the user to look down the list but am not filling the page with data.

    i hope this is clear enough, any suggestions would be grately appreciated.

    EDIT - I have just managed to add a spreadsheet to one of the pages on the userform. using this previous thread topic,

    http://www.excelforum.com/showthread.php?t=586636&highlight=user+form+multi+page

    but cannot seem to find out how to fill it with data from the other sheets within my workbook.......anyone got any suggestions?
    Last edited by peejay; 02-26-2007 at 06:55 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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