VBA help... How to stay on current textbox

hsiddique · #1 (**permalink**) 12-29-11, 10:41

Hi all,

I have a textbox that checks where the value entered (in this case Year) is in the past, present or future.

If it is in the past a msgbox appears, The users will click OK, but the cursor goes to the next textbox, rather then staying on the textbox that needs to be corrected.

Any ideas on how to stay on the textbox?

Thanks

Halil

healdem · #2 (**permalink**) 12-29-11, 11:07

use the setfocus function in the code that handles the message box.
alternatively redesign your code to include a date picker that doesn't allow the users to choose an invalid date

hsiddique · #3 (**permalink**) 12-29-11, 11:26

Hi,

I've added it but still no go

Code:

            If txtStartDate.Text < iYear Then
                MsgBox "Please enter a year that is not in the past", vbCritical, "Please enter Year..."
                frmCityDev.txtStartDate.SetFocus

            End If

It still goes to the next textbox.

Internet Services

Web Development

Digital Marketing

Consumer Tech