Multipage Userform
 

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

Multipage Userform
 

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