By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,515 Members | 1,363 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,515 IT Pros & Developers. It's quick & easy.

Creating a Yes/No popup in a VBA userform

P: 7
I am using the JWalk Enhanced data form and have purchased the VBA password. I would like to have decision pop up window that appears when the user clicks close because it needs to prompt the user to either save and exit or just exit. I've managed to get an information pop up window to appear with the appropriate text, but would like to have a pop up with a yes button and a no button. I know the code needed for what happens after the buttons are pressed but don't know the code for getting the pop up with the 2 buttons. Any help would be great.
Apr 13 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 5K+
P: 8,434
Are you using the MsgBox function to display the popup? If so, you just change the parameters to include the yes and no buttons.
Apr 14 '07 #2

P: 7
Yes i'm using the msgbox function, but that's what i'm having trouble with. I don't really know what code to write or change in order to do this.
Apr 17 '07 #3

P: 103
after the Prompt Option is the buttons option
Expand|Select|Wrap|Line Numbers
  1. msgbox("prompt",vbYesNo,...
Apr 17 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.