By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,049 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Tabbed Userform

P: 9
I have a userform with several tabbed sheets within it, what code do I need to use to select different tabs automatically in VB?

I want to be able to tell the macro to run page 1 on startup and a "next" function on each sheet to select the next tabbed sheet
Jan 17 '08 #1
Share this Question
Share on Google+
3 Replies


Expert 5K+
P: 8,434
I have a userform with several tabbed sheets within it, what code do I need to use to select different tabs automatically in VB?

I want to be able to tell the macro to run page 1 on startup and a "next" function on each sheet to select the next tabbed sheet
Judging from your use of the term "userform" this is probably not VB at all, but VBA. Is that right? If so, in what product (Eg. Word, Excel, Access, etc.)? If not, what version of VB?
Jan 18 '08 #2

P: 7
Lets say you have a button on your userform that when pressed by the user will go to the next tab on your userform. The code you would have on your button click procedure is as follows:
MultiPage1.Value = 1

Note: the first page has a value of 0, the second page has a value of 1 and so on. Set the value = to which page you want it to take focus on.
Jan 18 '08 #3

Ali Rizwan
100+
P: 927
I have some controls doing suchj things i ll upload them today or tommorrow in Howto's you can get them from HowTo's Forum.

Regards
>> ALI <<
Jan 29 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.