mesage box yes or no

[Todd_M]

Hi-
Im using a mesage box on userform1 that pops up when the user presses the commandbutton. The mesage box asks a question, then gives a choice of yes or no. If yes is selected I want userform1.hide and userform2.show. if no is selected I want userform1.hide and userform3.show. How do you write this in code in the userform1 commandbutton click()?

 

[Ivan F Moala]

On 2002-03-02 07:37, Todd_M wrote:
Hi-
Im using a mesage box on userform1 that pops up when the user presses the commandbutton. The mesage box asks a question, then gives a choice of yes or no. If yes is selected I want userform1.hide and userform2.show. if no is selected I want userform1.hide and userform3.show. How do you write this in code in the userform1 commandbutton click()?

dim Ans as string
Ans = msgbox("your Q",Vbyesno)
if Ans = vbyes then
userform1.hide
userform2.show
else
userform1.hide
userform3.show
endif


Ivan

 

[Todd_M]

Thanks Ivan- this works great