Solved

Display excel worksheet cell range in a userform control.

Posted on 2004-10-12
3
486 Views
Last Modified: 2008-03-17
Hi all,
I have an excel application with a GUI based on userforms. I need to view the contents (tables and charts) of a worksheets in a userform or separate window as the result of the calculations performed by the app.
Can't figure out how to place the contents of the results worksheet in a userform.
Every hint appreciated.
Thanks
0
Comment
Question by:lorenze
3 Comments
 
LVL 16

Accepted Solution

by:
jimbobmcgee earned 125 total points
ID: 12297025
Simplest way I can think of is to muck about with the Excel object, in Excel.  For instance, if you right-click your design toolbox, you can choose additional controls.  There should be two there called Microsoft Office Spreadsheet (version no.) and Microsoft Office Chart (version no.) that you could manipulate, I'm sure...
0
 

Author Comment

by:lorenze
ID: 12560755
Thanks for your post jimbobmcgee. I have considered the question answered allthough I was thinking of something in the way of a print preview inside the userform.
Regards and my apollogies for the delay.
0

Featured Post

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question