mesage box yes or no

Todd_M · Mar 2nd, 2002, 08:37 AM

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 · Mar 2nd, 2002, 08:44 AM

Quote:

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 · Mar 2nd, 2002, 08:59 AM

Thanks Ivan- this works great

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 2nd, 2002, 08:37 AM	#1
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	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()?

Mar 2nd, 2002, 08:59 AM	#3
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Thanks Ivan- this works great