Creating a Yes/No popup in a VBA userform

[bill1313]

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.

[Killer42]

Are you using the MsgBox function to display the popup? If so, you just change the parameters to include the yes and no buttons.

[bill1313]

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.

[Tig201]

after the Prompt Option is the buttons option

msgbox("prompt",vbYesNo,...