Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am creating a user form and am trying to include in the code behind the
form functionality that will ensure that the user has filled in all of the required information. So I have a long "Validate Self" procedure that depends on a series of message boxes to tell the user that various bits of information have not been provided. Here's an example: Else If txtUserEmail.Value = "" Then 'if the user has not entered a name in the text box Dim Answer As VbMsgBoxResult Answer = MsgBox("You have not entered your e-mail address.", vbOKCancel) If Answer = 2 Then Exit Function Else Exit Function txtUserEmail.SetFocus End If End If End If What happens is that the message box doesn't disappear on the first click of any of the buttons or the "x" at the top right of the box. It takes several clicks for the message box to decide it's okay to disappear. And then, when it does disappear, it's not at all clear that the txtUserEmail text box is what has the focus. Any suggestions as to what I am doing wrong would be greatly appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SetFocus? | Excel Programming | |||
SetFocus on a different sheet in VBA | Excel Discussion (Misc queries) | |||
setfocus | Excel Programming | |||
SetFocus Question | Excel Programming | |||
SetFocus method in VBA | Excel Programming |