Just full of ?'s today vbOkay Cancel

[itsme2]

Thanks for all the help so far so good as they say...

Why does this always run the application no matter whether "Cancel" or Okay is selected?

As you can see I've been trying several solutions however, am I missing the big picture here or something? I thought "Cancel was Cancel no matter what but, in my case "Cancel" is still running my next macro

If Range("B1") = "ABC" Then
        MsgBox "ABC", vbOKCancel & " for " & Range("A6").Value
        'ActiveSheet.Delete
        'Exit Sub
        'Else
        Application.Run "ABC"
        'Exit Sub
    End If

I wanted the message box to run like this under the above If statement but by golly, no go

MsgBox Range("B1").Value & " " & Range("A6").Value & Range("A7").Value, vbOKCancel

but the If statement before it makes excel a very unhappy person

 

[erik.van.geit]

Hi,

do some test with this
you pust put the "click-choice" in a variable

Sub test()
Dim response As Integer

If Range("B1") = "ABC" Then
    response = MsgBox("ABC", vbOKCancel, " for " & Range("A6").Value)
    If response = vbOK Then Application.Run "ABC"
End If
End Sub

Sub ABC()
MsgBox "ABC"
End Sub

compact

Sub another()
If MsgBox("do you?", vbOKCancel, "title") = vbOK Then MsgBox "OK" Else MsgBox "cancel"
End Sub

kind regards,
Erik

 

[itsme2]

Thanks ran with that and all is well thank you very much!!!!!

One other question regarding message boxes... how can you make a new line for each field in the message box ex

abc
def
ghi

Okay Cancel

IS what the message box would appear to look like in case the strings are very long ... if you know what I mean...

 

[erik.van.geit]

a linefeed would do
vbLf

msg = "abc" & vbLf & "def"
Msgbox msg, vbOkCancel, "title"

 

[itsme2]

Great thanks couldn't remember nor find anything on VB lineFeed

Great Help Today Thanks a Bunch!!!!!!

 

[erik.van.geit]

find anything on VB lineFeed

click in the item vbLf within your code
now hit function key F1
you will get a lot of info

 

[itsme2]

Oh Thanks!!!!