Results 1 to 6 of 6

pop up form within userform to confirm choice

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    MS-Off Ver
    Excel 2007 (also have access to Excel 2000/2003)
    Posts
    368

    pop up form within userform to confirm choice

    Hi,

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

    Private Sub CommandButton2_Click()
    'Pop up to double check
         ClearCheck.Show
    'Clear Page One
        Me.Actnumber1.Value = ""
        Me.How1.Value = ""
        Me.Whoact11.Value = ""
        Me.Whoact12.Value = ""
        Me.Whoact13.Value = ""
        Me.Act1Date.Value = ""
        Me.Comp11.Value = ""
        Me.Result11.Value = ""
        
    End Sub
    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:

    Private Sub CommandButton1_Click()
    Unload Me
    End Sub
    
    Private Sub CommandButton2_Click()
    
    End Sub
    Thank you in advance.
    Last edited by jpruffle; 05-11-2009 at 12:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1