populate message box from the second running the macro

[Mussa]

Hi
I have procedure to populate message box before the run my macro

ans = MsgBox("are you sure you want to continue ?", vbYesNo)
If ans = vbNo Then Exit Sub
'my macro
'
'

what I want the message box should show from the second running when click the button for my macro , not from the first time click the button , is it possible , guys?

 

[dmt32]

Hi Dave ,
my goal if i run the first time then will call my macro , also if run again then will show message and if I click ok should call my macro , but if I click no then should not call my macro .

Try this update & see if this now does what you want

Sub Mussa()
  
    With Sheet1.Range("A1")
        If Val(.ID) = xlDialogDisplay Then
            'display msgbox
            If MsgBox("are you sure you want To continue ?", 36, "Continue") = vbNo Then Exit Sub
        End If
        .ID = xlDialogDisplay
    End With
   
    Call mymacro
   
End Sub

Dave

 

[Dan_W]

also your guessing is too stupid !

The phrase "stupid question" is a reference to the question that PeteWright was about to ask. Not yours. Your response, however, was staggeringly rude.

 

[Mussa]

Wow Dave !
that's excellent , what I wanted.
thank you so much for your help .

 

[Mussa]

Use the code I posted in post #7 and put your macro code where it says "my macro"

I prefer post # 15 and works .
thank you for your time & help .