Displaying a Spreadsheet in a User Form

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

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