ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   change from page1 to page2 of MultiPage object (https://www.excelbanter.com/excel-programming/346170-change-page1-page2-multipage-object.html)

BigDave[_27_]

change from page1 to page2 of MultiPage object
 

On page 1 of a multipage object I have a "Next" button I want the use
to click to switch them to page 2. I already have a few lines of cod
taking data from the objects on page 1 and placing them in m
workbook.

TI

--
BigDav
-----------------------------------------------------------------------
BigDave's Profile: http://www.excelforum.com/member.php...nfo&userid=774
View this thread: http://www.excelforum.com/showthread.php?threadid=48690


Tom Ogilvy

change from page1 to page2 of MultiPage object
 
Me.Multipage1.Value = 1

Me.Multipage1.Value = 0 is the first page, 1 is the second, and so forth.

--
Regards,
Tom Ogilvy


"BigDave" wrote in
message ...

On page 1 of a multipage object I have a "Next" button I want the user
to click to switch them to page 2. I already have a few lines of code
taking data from the objects on page 1 and placing them in my
workbook.

TIA


--
BigDave
------------------------------------------------------------------------
BigDave's Profile:

http://www.excelforum.com/member.php...fo&userid=7741
View this thread: http://www.excelforum.com/showthread...hreadid=486907





All times are GMT +1. The time now is 12:07 PM.

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