pop up form within userform to confirm choice

**jpruffle** · 05-11-2009, 05:16 AM

Hi,

I have a button within a userform that clears the form:

Please Login or Register  to view this content.

What I want is when it is clicked the userform ClearCheck is shown that basically asks - Are you sure you wish to continue Yes/No.

If Yes I want the rest of the above Sub to continue. If No then Stop.

Can you advise. The ClearCheck code is below:

Please Login or Register  to view this content.

Thank you in advance.

**ravinder_tigh** · 05-11-2009, 05:22 AM

Sub Msgbox_Yes_No()
Dim Response As Integer
Response = MsgBox(prompt:="Select 'Yes' or 'No'.", Buttons:=vbYesNo)
' if user selects yes, i would like to macro(Yes) to continue running
If Response = vbYes Then
Resume
Else
' if the user selects no, exit or whtevr code

End If
End Sub

you could use a message box for this case and that could be even fired from any worksheet or workbook event

**royUK** · 05-11-2009, 05:31 AM

As suggested just use a message box

Please Login or Register  to view this content.

This would be simpler

Please Login or Register  to view this content.

**jpruffle** · 05-11-2009, 07:25 AM

Thank you both for your suggestions.

Roy I like your idea of clearing the form without referencing. But two things: Firstly my form is a multipage form and I would like the ability for the button just to clear page1 for example (The button resides on Page1). Secondly is there a way to omit two of the items from being cleared:

ComboBox - SelectAct1
and a textbox - ActNumber1?

Thanks in advance.