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????? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exit Field vs Exit Button......
<<If the cursor is positioned on the Name field, execution goes to the
txdtName_Exit routine before exiting! This is probably because the focus on the form is exiting the Name field to go to the Exit button. Maybe you could just move the code from the txtName_Exit routine to the ExitButton_Click routine. Do you really need to check the value the moment the user leaves the field to change something else. Maybe they are going to come back and correct the Name field before finalizing their input anyway. Or is the Name field required to be correct before other fields can be set properly? -- Regards, Bill Renaud |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exit Field vs Exit Button......
Yes, this name field is required and the edit logic was built on the idea
that there was no point in continuing to other fields when the "#1" field was incorrect. I was hoping that there would be some control I could test within the name edit routine to check if the even was triggered when the Exit button had been pressed. That would greatly simplify things, but I haven't been able to find the right condition. I know it must be there - just out of the grasp of my feeble mind....... "Bill Renaud" wrote: <<If the cursor is positioned on the Name field, execution goes to the txdtName_Exit routine before exiting! This is probably because the focus on the form is exiting the Name field to go to the Exit button. Maybe you could just move the code from the txtName_Exit routine to the ExitButton_Click routine. Do you really need to check the value the moment the user leaves the field to change something else. Maybe they are going to come back and correct the Name field before finalizing their input anyway. Or is the Name field required to be correct before other fields can be set properly? -- Regards, Bill Renaud |
Reply |
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 |