Excel displayed in a userform

Hi all

Is it possible to display excel data in a userform as some sort of add in, I basically want based on my selection on the userform display the excel results below the selection? and if possible how do I do it

Also is there a command that can autofit your userform depending on the computers screen size or not and if possible how?

Txs
Peter

I'm not clear on what you need exactly. You can display data from a worksheet in various ways, such as a listbox on the userform.

Hi Nu2Java

Txs for replying, sorry let my try again, on my userform I have for example a date selection eg 1 Jan 2013 - 31 Jan 2013, that once selected will display for example the following data in excel can I display this data on a userform so it basically looks like an excel sheet on a part of the userform:

No Name Cost Sold Amount
1 Apple 5 2 10
2 Pear 10 4 40
3 Banana 15 6 90
4 Orange 20 8 160


Txs
Peter