ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to show a userform using excel macro in multipage (https://www.excelbanter.com/excel-programming/296303-how-show-userform-using-excel-macro-multipage.html)

Solomon B

How to show a userform using excel macro in multipage
 
The name of the userform is userform10 and when I wrote a
code
Private commandbutton15_Click
Userform10.show
end sub

It does not open and shows me "out of memory" error
message. Please I desperately need help on how to show
the userform with multiple pages.

ross

How to show a userform using excel macro in multipage
 
Try loading all you forms at when the spead sheet is opened, this may
overcome the memory issue.

the .show method should actually load the form, but the memory issue
might be due to the size of the form.

Good Luck
Ross


All times are GMT +1. The time now is 03:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com