Userforms

Rusty · Apr 19th, 2002, 05:58 AM

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 · Apr 19th, 2002, 05:59 AM

Could you not just use the multipage control?

Mudface · Apr 19th, 2002, 06:03 AM

Alternatively have a look here: -

http://www.mrexcel.com/board/viewtop...c=3719&forum=2

Rusty · Apr 19th, 2002, 06:04 AM

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 · Apr 19th, 2002, 06:05 AM

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 · Apr 19th, 2002, 06:08 AM

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 · Apr 19th, 2002, 06:11 AM

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 · Apr 19th, 2002, 06:12 AM

Buntykins,

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

Mudface · Apr 19th, 2002, 06:16 AM

Pffftt, so-called Audiojoe.

Audiojoe · Apr 19th, 2002, 06:20 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 05:58 AM	#1
Rusty Board Regular Join Date: Apr 2002 Location: Ithaca Posts: 107	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

Apr 19th, 2002, 05:59 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Could you not just use the multipage control?

Apr 19th, 2002, 06:03 AM	#3
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Alternatively have a look here: - http://www.mrexcel.com/board/viewtop...c=3719&forum=2

Apr 19th, 2002, 06:04 AM	#4
Rusty Board Regular Join Date: Apr 2002 Location: Ithaca Posts: 107	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

Apr 19th, 2002, 06:05 AM	#5
buntykins Board Regular Join Date: Apr 2002 Posts: 76	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

Apr 19th, 2002, 06:08 AM	#6
Rusty Board Regular Join Date: Apr 2002 Location: Ithaca Posts: 107	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?

Apr 19th, 2002, 06:11 AM	#7
buntykins Board Regular Join Date: Apr 2002 Posts: 76	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

Apr 19th, 2002, 06:12 AM	#8
Rusty Board Regular Join Date: Apr 2002 Location: Ithaca Posts: 107	Buntykins, To be honest, I didn't see it. I guess I'd better take another look.......

Apr 19th, 2002, 06:16 AM	#9
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Pffftt, so-called Audiojoe.

Apr 19th, 2002, 06:20 AM	#10
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	So-called?? It's right there in bold...Mudface...