I would like the MsgBox in a vba module to run but I don't want to require the user to click on Okay I wrote coding to return to the empty field and change the border to bold red. Which vb* can I use to have the messge appear BUT not require a response?
If cmbxErrSource.Value = "3" Then
MsgBox "If the Source of Issue is HOME OFFICE this field is REQUIRED", vbOKOnly + vbInformation, "Required Field"
Me!cmbxIssueDes.BorderColor = lngRed
Me!cmbxIssueDes.ForeColor = lngRed
Me!cmbxIssueDes.BackColor = lngWhite