No response for MsgBox

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.SetFocus
             Me.cmbxIssueDes.Dropdown
             Me!cmbxIssueDes.BorderColor = lngRed
             Me!cmbxIssueDes.ForeColor = lngRed
             Me!cmbxIssueDes.BackColor = lngWhite

Open in new window

eyes59Asked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
eyes59

Another option would be to use the "Web Form" method, which most websites have adopted, because of the hatred of popups.

Modify your existing code that pops up the message, to just turn on an "Empty Field Alert" Label.

Screenshot attached.

JeffCoachman


untitled.JPG
0
 
Patrick MatthewsCommented:
Hello eyes59,

MsgBox *always* requires the user to clear it by clicking something.  If you want to show a message to the
user without waiting for the user to do something, then you will need to create your own form, which you
can make modeless if you want.

Regards,

Patrick
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.