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.

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