• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • Last Modified:

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

0
eyes59
Asked:
eyes59
1 Solution
 
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
 
Jeffrey CoachmanCommented:
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

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now