Userforms

[Rusty]

Hi,

Daft question this, but:

I have some userforms with multiple pages on them and I want to put in buttons, so that if you push the button on page 1, it will flick you to page 2.

But I can't remeber / figure out the code to do this........

TIA, Rusty

 

[Mudface]

Could you not just use the multipage control?

 

[Mudface]

Alternatively have a look here: -

http://www.mrexcel.com/board/viewtopic.php?topic=3719&forum=2

 

[Rusty]

As in clicking on the tabs at the top?

Yeah, just curious how to do it with buttons, and also the code to actually select the different sheets.

As in when you load up the user form, it shows page one.

Then I select page 2 then unload.

When I select the userform again, it starts on page 2.

So mainly curiousity I guess...

Thanks for the reply

 

[buntykins]

Audiojoe has a thing on his userform tutorial about moving it with buttons, why dont you get it from him?

I tried posting a mail he sent me about it but the format went crazy

Janie x

 

[Rusty]

Mudface,

Thanks very much for the link, much appreciated. I did a search, but couldn't find anything.

I'll look into that.
----------

Buntykins,

AudioJoe sent me a copy of that, you want I try sending to you as well?

 

[buntykins]

No I have it thanks. There is an example of multipages being controlled by buttons in there though, did you not see it? I was going to use it for a userform I'm doing

Janie

xx

 

[Rusty]

Buntykins,

To be honest, I didn't see it. I guess I'd better take another look.......

 

[Mudface]

Pffftt, so-called Audiojoe.

 

[Audiojoe]

So-called?? It's right there in bold...Mudface...