Tabbed Userform

[woolls01]

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

[Killer42]

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?

[brenty66]

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.Valu e = 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.

[Ali Rizwan]

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 <<