Displaying a Spreadsheet in a User Form

Last Updated on Fri, 20 Sep 2019 | Excel 2003 VBA

Vertex42 The Excel Nexus

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!

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

Was this article helpful?

Responses

wegahta
How to display spreadsheet in userform Excel?

8 years ago
- Reply
Markus
How to Display shapes in Xcel VBA Userform Spreadsheet?

8 years ago
- Reply
ann
How insert excel in user form and vlookup in user form excel?

3 years ago
- Reply
Hana Davidson
How to show excel spreadsheet on userform?

2 years ago
- Reply
Silke
How to show a spreadsheet in a form vba?

11 months ago
- Reply
fernando
How to display a worksheet on a userform?

8 months ago
- Reply
arcangelo
How to display Excel macro form?

8 months ago
- Reply
VANESSA
How to make userform worksheet sheet?

7 months ago
- Reply
Melissa
How to insert a excel sheet in vba userform?

6 months ago
- Reply
erkki kalliom
How to imbed a user form on an excel spreadsheet?

3 months ago
- Reply
juliane
How to display sheet in userform?

3 months ago
- Reply
UWE
How to put and use worksheet in userform excel?

1 month ago
- Reply
gilda
How to embeded userform in excel sheet?

27 days ago
- Reply

Engram 9 VBA Scripts

» Excel 2003 VBA