How to show a userform using excel macro in multipage

S

Solomon B

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.
 
R

ross

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top