ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   User form (https://www.excelbanter.com/excel-discussion-misc-queries/253294-user-form.html)

Brad

User form
 
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?



Brad

User form
 
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?




All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com