Forum Discussion
Send emails from a multiple user spreadsheet
Hi I'm not a proficient VBA user so apologies in advance if my request isn't clear. We have a spreadsheet that users can log 'issues' into. The spreadsheet is on SharePoint and is not check in/out...
You can write codes inside Worksheet_Change event. See below example.
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo HarunErrHandler
If Not Application.Intersect(Target, Range("B:B")) Is Nothing Then
If Target = "In-Progress" Then
MsgBox "Write codes here for sending mail."
End If
End If
Exit Sub
HarunErrHandler:
MessageBox = MsgBox("Error Number: " & Err.Number & vbCrLf & Err.Description, vbCritical, "Error")
End Sub