I'm trying use user forms rather than entering information directly into cells.

Based on two inputs, there will be one of three input screeens that will
need to be completed. I'm thinking that the multipage form is the way to go
and have it programmically go to appropriate tab. Everyting that I seen has
said added pages is easy, but don't say how it is done.

If this is the approach that I should use, how do I add a page the default
is two?
Would there be a better approach to use?

After another day of digging around, fournd a rather easy way to do this -
you have to right click on the tab.


"Brad" wrote:

I'm trying use user forms rather than entering information directly into cells.

Based on two inputs, there will be one of three input screeens that will
need to be completed. I'm thinking that the multipage form is the way to go
and have it programmically go to appropriate tab. Everyting that I seen has
said added pages is easy, but don't say how it is done.

If this is the approach that I should use, how do I add a page the default
is two?
Would there be a better approach to use?