Userform output, once macro is run

[tdownwa]

Hi all,

I have a userform that contains a "Run" command button, which outputs the data from the userform to a worksheet(s) and runs a macro combining the worksheets together and removing dublicate data.

What Im wondering is once the macro is complete is it possible to take that output and send it back into a second userform that displays the results?

If so, my macro takes two worksheets and after combining the data together and removing the duplicate info, leaves the "output" in worksheet1. My thought is somehow importing those results into a new userform which will be printable.

Here's my current userform code:


<!-- BEGIN TEMPLATE: bbcode_code -->Code:
Private Sub CommandButton1_Click()
Call Macro1
End Sub
Private Sub TextBox1_Change()
Sheet1.Range("A1").PasteSpecial Paste:=xlPasteFormulasAndNumberFormats = Me.TextBox1.Value
End Sub
Private Sub TextBox2_Change()
Sheet2.Range("A1").PasteSpecial Paste:=xlPasteFormulasAndNumberFormats = Me.TextBox2.Value
End Sub

<STYLE>.alt2 font {font: 11px monospace !important;color: #333 !important;}</STYLE>