Excel worksheet contents as result in a userform.

[Ernie]

Hi all,
I'm trying to present a worksheet range as the result of calculations in
a userform or separate window as a result of clicking a command button.
i can't figure out how to show this worksheet range in my results userform.
What control object can I use for this purpose?

 

[AndrewAK]

Are you at a point ware you just need to insert the data from the use
form, or do you still need to calculate the data and then insert it
:confused

 

[N10]

Try converting the calculated range to a string variable and show it in a
text box

 

[Ernie]

Hi Andrew,
Calculations are all done and I want to show the results in a userform.

 

[Ernie]

This might not work as I have charts in my worksheet that go with each
table in it.

 

[N10]

Hi Ernie

If all you want to do is show a representation of some range purely for
informarion in a userform then what I suggested would work.

What exactly are you trying to achieve ?

Best N10

 

[Ernie]

Hi N10,
My results worksheet contains tables and graphs. I need to show a
representation similar to the print preview in a userform.
I have never tried to convert a worksheet range to a string var, but am
willing to give it a try.
Regards, Ernie