Multipage Userform

[mjack003]

Is it possible to have a multipage userform without the tabstrip? I have a userform with numerous objects that I hide and show on various events and this is very time consuming and clustered. It would be much easier to have seperate pages for each event such as a button click. I don't want the user to be able to see the tabstrip so they are forced to push a button to perform an action. Also, if this is possible, how can I view the seperate pages for setting up objects? Any suggestions would be great.

Thanks,
Mjack

[Toppers]

Hi,
in VBA

Multipage1.Style=2

OR

View properties of Multipage1 (or whatever your form is called) and set
Style=2

HTH

"mjack003" wrote:

>
> Is it possible to have a multipage userform without the tabstrip? I
> have a userform with numerous objects that I hide and show on various
> events and this is very time consuming and clustered. It would be much
> easier to have seperate pages for each event such as a button click. I
> don't want the user to be able to see the tabstrip so they are forced
> to push a button to perform an action. Also, if this is possible, how
> can I view the seperate pages for setting up objects? Any suggestions
> would be great.
>
> Thanks,
> Mjack
>
>
> --
> mjack003
> ------------------------------------------------------------------------
> mjack003's Profile: http://www.excelforum.com/member.php...fo&userid=5141
> View this thread: http://www.excelforum.com/showthread...hreadid=497128
>
>