Displaying a Spreadsheet in a User Form

Last Updated on Thu, 30 Apr 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?

+14 -20
« 
 »

Recommended

Professional Excel Templates

Professional Excel Templates

Related Posts

Related Categories

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

Responses

  • Hana Davidson
    How to show excel spreadsheet on userform?
    2 years ago
  • Silke
    How to show a spreadsheet in a form vba?
    2 years 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?
    1 year ago
  • Melissa
    How to insert a excel sheet in vba userform?
    1 year ago
  • erkki kalliom
    How to imbed a user form on an excel spreadsheet?
    11 months ago
  • juliane
    How to display sheet in userform?
    10 months ago
  • UWE
    How to put and use worksheet in userform excel?
    9 months ago
  • gilda
    How to embeded userform in excel sheet?
    8 months ago
  • selma hurmerinta
    How to view excel table in userform?
    7 months ago
  • robert
    How to put a excel sheet in VBA User form?
    6 months ago
  • barbara
    How to display form on excel sheet?
    6 months ago
  • Cottar
    How to show excel as a form?
    6 months ago
  • martin
    How to show excel sheet in form in vba?
    6 months ago
  • benedetta
    How to visualize excel sheet to userform vba?
    6 months ago
  • Karin Frei
    How to display the contence of a sheet on a user form with vba?
    5 months ago
  • luigia bellucci
    How to display forms in Excel?
    4 months ago
  • idris
    How to get microsoft office chart 11.0 in additional control excel vba?
    4 months ago
  • Kieron
    How to display the results of a table within an excel userform?
    4 months ago
  • Felix Werfel
    How to insert vba form to sheet in excel?
    4 months ago
  • selam
    How to view excel spreadsheet in form view?
    2 months ago
  • sandra
    How to show a part of a sheet in a userform vba?
    2 months ago
  • hamfast underhill
    How to display excel userform rowsource dynamic table?
    1 month ago
  • Gabriele Russo
    How to embed spreadsheet in excel vba form?
    25 days ago

Post a comment