Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exit Field vs Exit Button......
Just hit a weird one he I'm working with data validation on a form. The
first field on this for is a "must fill" and I check this with an event: Private Sub txtName_Exit(ByVal Cancel As MSForms.ReturnBoolean) if txtName.Value = "" then error message stuff When I hit the button to exit the screen, I expect to execute the following code: Private Sub ExitButton_Click() Unload Me MainMenu.Show End Sub But!!! If the cursor is positioned on the Name field, execution goes to the txdtName_Exit routine before exiting! I've been searching for an event to capture this and bypass the error message, but have had no luck so far. Suggestions????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i make a button from a userform exit onto the document in . | New Users to Excel | |||
macro on exit of field | Excel Programming | |||
Disable Exit button on a UserForm | Excel Discussion (Misc queries) | |||
Userform Exit button | Excel Programming | |||
If a called sub exit, how to the caller exit right away? | Excel Programming |