Cycle through multi-pages with spin button

**adam2308** · 01-21-2010, 07:25 PM

On the attached example i have a button on sheet1 which opens a form. On this form i have four pages of a multi-page control and below it i have a spin button. What i want is for when the spin button is pressed to the right then the multi-page moves up to the next page and vice-versa for the left spin button. How do i write this code?

Thanks,
Adam.

**Leith Ross** · 01-21-2010, 07:47 PM

Hello adam2308,

Here is the code for the UserForm...

Please Login or Register  to view this content.

**adam2308** · 01-21-2010, 08:02 PM

Thanks Leith!!

**ashish2k15** · 07-23-2013, 03:15 AM

Hi,

Just a small doubt

Min value of multipage control is 0, If min value of spinbutton is set as 0.

Then "MultiPage1.Value = SpinButton1.Value - 1" can go to extreme left of first page (blank page only).

min value of spin button should be 1

Or am I missing something

(very new to excel and VBA)

**arlu1201** · 07-23-2013, 04:48 AM

Ashish,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.