Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 497
  • Last Modified:

Display excel worksheet cell range in a userform control.

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
lorenze
Asked:
lorenze
1 Solution
 
jimbobmcgeeCommented:
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
 
lorenzeAuthor Commented:
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now