⟩ Can I ask my user for confirmation before executing the macro?
Sub AskAndDo()
If MsgBox("Are you sure ?", vbYesNo + vbQuestion) = vbNo _
Then Exit Sub
'Code goes here instead of
MsgBox "Actions here"
End Sub
Question and Answer:
Home MS Excel
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
I want to add a toolbar to my spreadsheet that when clicked, brings up Userform1?
When a button is drawn onto a sheet the assign macro is not displayed. When right-clicking on the button the "Assign Macro" context menu item is not present?
How do I run a macro every time a certain cell changes its value?
I want to show a userform each time my file is opened?
Is there a way to protect the macros I create so people can not see or alter them?
Is it possible to call a macro from the condition true or false side of a worksheet formula? i.e. If(A2="OK",Run macro1,run macro2)?
How can I save a chart as a GIF file?
How can I print a workbooks full path in the header or footer? The Page Setup dialog box does not seem to offer the option.?
How can I enter the current date into a cell so it does not change from day to day? When I use the NOW function, it always shows the current date?
I need to determine the difference between two times. If the difference is positive, it works fine. But Excel does not want to display negative time values. Why not?
