populate message box from the second running the macro

M

Mussa

Board Regular
Joined
Jul 12, 2021
Messages
245
Office Version
  1. 2019
  2. 2010
Hi
I have procedure to populate message box before the run my macro
VBA Code: 
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?
 
Sort by date Sort by votes
Mussa said:
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 .
Click to expand...

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

VBA Code: 
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
 
Upvote 0
Solution

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Mussa said:
also your guessing is too stupid !
Click to expand...
The phrase "stupid question" is a reference to the question that PeteWright was about to ask. Not yours. Your response, however, was staggeringly rude.
 
Upvote 0
Wow Dave !
that's excellent , what I wanted.
thank you so much for your help .:)
 
Upvote 0
Use the code I posted in post #7 and put your macro code where it says "my macro"
Click to expand...
I prefer post # 15 and works .
thank you for your time & help .;)
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
procedure to populate message box with yes or no if I run the macro
Replies
3
Views
224
Michael M
Michael M
B
  • Question
Event code to give message box and change color of auto-shape
Replies
4
Views
333
bh24524
B
S
  • Solved
add a message box if a match using a userform list box doesn't match
Replies
7
Views
274
still learning
S
H
  • Solved
Macro to bold certain text in Message Box
Replies
2
Views
116
howard
H
E
  • Question
Excel VBA to Outlook Email Draft - How to save email draft copy to sharepoint / How to use template from sharepoint?
Replies
0
Views
385
elitef
E

Forum statistics

Threads
1,216,500
Messages
6,131,015
Members
449,615
Latest member
Nic0la

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top