MsgBox cancel or Continue macro

[jl2509]

Hi

Can anyone advise for a macro that will check cell A2 for a value of "True"
If cell A2 does contain "True" then return a messagebox "Are you sure this is the correct selection?" vbyesno
if vbyes is pressed then continue with code or if no is selected exit sub

This must be run from a command button as this is a print routine.

I know this is miles away, but this is my thought process.

If Range("A2") = True Then

MsgBox "Are you sure this is the correct selection?", vbYesNo
if response = vbYes
continue code
.....
.....
if response = vbno then
exit sub


many thanks

 

[James006]

Hi,

There are plenty of examples all over the web ...

https://www.automateexcel.com/vba/yes-no-message-box/


By the ways ... have you cross-posted ... ???

https://www.ozgrid.com/forum/forum/...-check-option-buttons-and-continue-or-end-sub

 

[gallen]

Sub CheckIt()    Dim s As String
    
    'set message
    s = "Are you sure this is the correct selection?"
    
    'make cae insesnsitive
    If UCase([A2]) = "TRUE" Then
        'ask question and leave if negative
        If MsgBox(s, vbYesNo) = vbNo Then Exit Sub
    End If
    
End Sub

 

[jl2509]

Thank you for the repsonse,

I know I cross posted but only in my haste to get a solution.

Thanks

 

[Fluff]

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.