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?

Hi,
How are you creating this UserForm?

Originally Posted by peejay

Sample workbook attached
(forgive the coding its me trying to get it worked out)

thanks in anticipation of any help

Hi peejay,
I am unable to open the userform, my xl doesn't have the objects, maybe somebody else will be able to open it