Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to get a message box to appear when the user doesn't fill in
required information. The following will do that, however, if the userform is closed, the message will still show up..I am new at all of this so any help would be greatly appreciated. Thanks in advance. Dawn Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) Dim mybox As String mybox = TextBox1.Text If Not IsEmpty(mybox) And mybox = "" Then MsgBox "Enter KanBan Number", vbOKOnly Cancel = True Else End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
userform always on top? | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming | |||
Userform inside another userform | Excel Programming | |||
userform | Excel Programming |