Microsoft Office Forums - View Single Post - [Solved] Message Box to advise corrective action required

Thread: [Solved] Message Box to advise corrective action required

View Single Post

Old

02-19-2017, 12:28 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Give this a try...

Code:

Sub Button1_Click()
    If activecell.Row > 7 Then
        Call OtherMacro
    ElseIf activecell.Row < 8 Then
        MsgBox "Marcro cannot be run on a row between 1 and 7"
        Exit Sub
    End If
End Sub

Reply With Quote