Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello fellow programmers!
If TextBox1.Value = "" Then MsgBox "You have not confirmed the Information." & vbNewLine & "Please type the Information in both boxes.", , " - Information Error - " With TextBox1 ..SetFocus End With Exit Sub End If If TextBox2.Value = "" Then MsgBox "You have not confirmed the Information." & vbNewLine & "Please type the Information in both boxes.", , " - Information Error - " With TextBox2 ..SetFocus End With Exit Sub End If If TextBox2.Value TextBox1.Value Then MsgBox "The Informations you have entered do not match. Please try again.", , " - Information Error - " With TextBox1 ..SetFocus End With Exit Sub End If If TextBox1.Value < TextBox2.Value Then MsgBox "The Informations you have entered do not match. Please try again.", , " - Information Error - " With TextBox2 ..SetFocus End With Exit Sub End If The message box displays twice and the SetFocus doesn't work...any ideas? Your help is much appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SetFocus? | Excel Programming | |||
setfocus | Excel Programming | |||
setfocus after a msgbox | Excel Programming | |||
setfocus after a msgbox | Excel Programming | |||
setfocus after a msgbox | Excel Programming |