I have written code for a message box prompt to allow the user to select Yes to continue or No to Exit sub
Where I select No, macro does not exit
Where I select No, macro does not exit
Code:
Sub MessageRangeValues()
Dim response
response = MsgBox("Has the macro been selected to range Value the data?", vbYesNo)
If response = vbNo Then
Exit Sub
Else
End If
End Sub [code]
It would be appreciated if someone could amend my code