I have a 5 page useform and would like to have command buttons on the bottom
of each page. One "PREV" and one "NEXT" button. If the user clicks the next
button the form will change to the next page with the first text box in focus
and similarly with the prev button it would switch to the prev page with the
first text box in focus on that page. Any help would be appreciated!

Hello Newbie1092,

Excel provides controls (arrows) to the left of tabs that do this.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=494716

A multipage control (which has pages and can be used on a userform) has tabs
on the bottom. What do you mean by a 5 page userform.

How do you designate the first textbox for each page.

--
Regards,
Tom Ogilvy

"Newbie1092" wrote in message
...
I have a 5 page useform and would like to have command buttons on the
bottom
of each page. One "PREV" and one "NEXT" button. If the user clicks the
next
button the form will change to the next page with the first text box in
focus
and similarly with the prev button it would switch to the prev page with
the
first text box in focus on that page. Any help would be appreciated!