Displaying excel data in pop up window???

[eddd82]

Im pretty much a beginner at vba and that. just wonderin ive figurd out how to change values in different tables, sheets etc but if i want to generate a report in a pop up window to display certain columns from the workbook how would this be achieved? Cheers

_________________
[Brian]
This message was edited by eddd82 on 2002-04-26 02:34

 

[eddd82]

Anyone out there??!!

 

[Legacy 98055]

Hi
You want to display cells in a userform?
Or labels stacked?
You can do both...
Tom

This message was edited by TsTom on 2002-04-26 02:47

 

[eddd82]

Basically what i want i have is a load of tables storing information. certain values can be changed using the forms ive already made. After the changes are made they have an option of viewing a report, which is basically a few of the columns extracted from the workbook and shown through the macro. any way at all would be great. (Do i make sense?)

 

[Legacy 98055]

How do you want to display your info in the userform?
Labels or cells...
You can insert a worksheet into a userform.
More sim[ple approach, for now, might be to just assign values to labels...
I gotta go for now...
Tom

 

[eddd82]

How do u assign values to the labels? Thanks