I have the following complex(!) macro;
Sub Post()
Range("B10").Select
ActiveCell.FormulaR1C1 = "on"
Range("B10").Select
ActiveCell.FormulaR1C1 = "off"
Range("B11").Select
End Sub
I have set up a button to run this macro.
When the user presses the button, I want something to appear saying "are you sure?" before the above is run. Options would be yes or no, and "yes" would run the macro, "no" would just return to the spreadsheet without doing anything.
Is there something I can insert into the above to achieve this?
Thanks (from a VB non-user)
Sub Post()
Range("B10").Select
ActiveCell.FormulaR1C1 = "on"
Range("B10").Select
ActiveCell.FormulaR1C1 = "off"
Range("B11").Select
End Sub
I have set up a button to run this macro.
When the user presses the button, I want something to appear saying "are you sure?" before the above is run. Options would be yes or no, and "yes" would run the macro, "no" would just return to the spreadsheet without doing anything.
Is there something I can insert into the above to achieve this?
Thanks (from a VB non-user)