Displaying excel data in pop up window???

eddd82 · Apr 26th, 2002, 03:04 AM

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 · Apr 26th, 2002, 03:43 AM

Anyone out there??!!

Tom Schreiner · Apr 26th, 2002, 03:46 AM

Quote:

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 · Apr 26th, 2002, 03:50 AM

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?)

Tom Schreiner · Apr 26th, 2002, 03:54 AM

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 · Apr 26th, 2002, 03:55 AM

How do u assign values to the labels? Thanks

Apr 26th, 2002, 03:43 AM	#2
eddd82 Board Regular Join Date: Apr 2002 Location: Ireland Posts: 107	Anyone out there??!! __________________ [Brian]

Apr 26th, 2002, 03:55 AM	#6
eddd82 Board Regular Join Date: Apr 2002 Location: Ireland Posts: 107	How do u assign values to the labels? Thanks __________________ [Brian]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 03:04 AM	#1
eddd82 Board Regular Join Date: Apr 2002 Location: Ireland Posts: 107	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 ]

Apr 26th, 2002, 03:50 AM	#4
eddd82 Board Regular Join Date: Apr 2002 Location: Ireland Posts: 107	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?)

Apr 26th, 2002, 03:54 AM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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