userform multipage problem

[mahaveer]

i have a userform with multipage1. On multipage1 there are 3 pages.

1 page = Creation

2 page = Suppliers (visible = false)

3 page = Inventory (visible = false)


on 1 page i have two command button.

1 command button = Add suppliers

2 command button = Add Inventory


the command on 1st command button is following:

Multipage1("page2").visible = true

Multipage1("Page2").enabled = true

Multipage1("Page3").visible = false


the command on 2nd command button is following:

Multipage1("page3").visible = true

Multipage1("Page3").enabled = true

Multipage1("Page2").visible = false


my Problem:

when my userform initialize then "creation" page automatically open only

now when i press the 1st command button i.e. add supplier then 2nd page "Suppliers" is visible but "supplier" page not open automatically still i m on creation page only why? is there any way to open the 2nd page from 1st command button on page1.

 

[NARAYANK991]

Hi Mahaveer ,


Check out these two links :


1. http://support.microsoft.com/kb/155374


2. http://www.excelforum.com/excel-programming-vba-macros/349639-userform-multipage-select-a-tab.html


According to them , you need to use something like :


Multipage1.Value = 0 to select the first page


Multipage1.Value = 1 to select the second page


Multipage1.Value = 2 to select the third page.


Narayan

 

[mahaveer]

answer:


I have to add one more line in 1st command button and 2nd command button at the end i.e.

multipage1.value = 1


now some one can tell me as i have got my answer of the above query that how to remove this question from here for save the time of all experts.

 

[sgmpatnaik]

@mahaveer


Hi


is it possible to upload a sample workbook


Thanks


SP

 

[mahaveer]

Thanks Narayank dear

i followed you trick but till i could not see you post

but thanks dear

your answer is best answer.

and thanks you to dear for your sgmpatnaik valuable time.