Displaying a Spreadsheet in a User Form

Last Updated on Mon, 27 Jan 2020 | Excel 2003 VBA

Vertex42 The Excel Nexus

Professional Excel Templates

Get Instant Access

Not content to simply display a chart in a UserForm? How about an entire spreadsheet?

Figure 15-15 shows an example of a UserForm that contains a Microsoft Office Spreadsheet 11.0 control. This control can contain an entire interactive spreadsheet, complete with formulas and formatting. In fact, this Spreadsheet control has a significant advantage over a standard Excel sheet: Its dimensions are 18,278 columns x 262,144 rows. This is nearly 300 times as many cells as a standard Excel worksheet!

Userform Chart
Figure 15-15: This UserForm contains a Spreadsheet control.

Was this article helpful?

+13 -14
« 
 »

Recommended

Professional Excel Templates

Professional Excel Templates

Related Posts

Related Categories

Spreadsheet, Excel Displays, Pivot Table, Excel Create, Excel 2003, Chart Excel, Excel Sheet

Responses

  • Hana Davidson
    How to show excel spreadsheet on userform?
    2 years ago
  • Silke
    How to show a spreadsheet in a form vba?
    1 year ago
  • fernando
    How to display a worksheet on a userform?
    1 year ago
  • arcangelo
    How to display Excel macro form?
    1 year ago
  • VANESSA
    How to make userform worksheet sheet?
    12 months ago
  • Melissa
    How to insert a excel sheet in vba userform?
    10 months ago
  • erkki kalliom
    How to imbed a user form on an excel spreadsheet?
    8 months ago
  • juliane
    How to display sheet in userform?
    7 months ago
  • UWE
    How to put and use worksheet in userform excel?
    6 months ago
  • gilda
    How to embeded userform in excel sheet?
    5 months ago
  • selma hurmerinta
    How to view excel table in userform?
    4 months ago
  • robert
    How to put a excel sheet in VBA User form?
    3 months ago
  • barbara
    How to display form on excel sheet?
    3 months ago
  • Cottar
    How to show excel as a form?
    3 months ago
  • martin
    How to show excel sheet in form in vba?
    3 months ago
  • benedetta
    How to visualize excel sheet to userform vba?
    3 months ago
  • Karin Frei
    How to display the contence of a sheet on a user form with vba?
    2 months ago
  • luigia bellucci
    How to display forms in Excel?
    1 month ago
  • idris
    How to get microsoft office chart 11.0 in additional control excel vba?
    1 month ago
  • Kieron
    How to display the results of a table within an excel userform?
    29 days ago
  • Felix Werfel
    How to insert vba form to sheet in excel?
    29 days ago

Post a comment