Displaying a Spreadsheet in a User Form
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.
Responses
-
wegahta8 years ago
- Reply
-
Markus7 years ago
- Reply
-
ann3 years ago
- Reply
-
Hana Davidson1 year ago
- Reply
-
Silke3 months ago
- Reply
-
fernando14 days ago
- Reply
-
arcangelo5 days ago
- Reply