I've searched, but I'm not asking Google the correct way...
I have a text box with an exit event that works just fine.
If I tab out, the event fires and my code runs. I then click a control and everything works as expected.
If I do not tab out, and instead click the other control, the exit event still fires just fine, but the clicked control doesn't run. I have to click it again.
I know this is going to be a simple, ID10T fix. :P
Probably ... but without the code, perhaps not.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
The website won't let me paste the code. It blocks it as a potential SQL Injection attack.
The code is otherwise straight forward. It's a simple: "Private Sub tunnelAtargetIP_Exit(ByVal Cancel As MSForms.ReturnBoolean)".
If I tab out, the exit code runs. Then, I can click the next Commandbutton and it runs.
If I exit the textbox by clicking the Commandbutton, the exit code runs but the Commandbutton_Click code does not. I can click the Commandbutton again and then it does run.
It seems like, when I click a control, that control_click won't run because the textbox_exit code isn't done yet?
Can you show me the textbox exit event code?
I have duplicated the condition in the most minimal way possible.
I made a form with a default textbox and a default command button.
Here is the associated code:
There is nothing else. No initialize code, nothing.
Please Login or Register to view this content.
Behavior...
I type "hello" into the textbox and tab out. What I type is displayed as "Exit code: hello".
I type "hello2" into the textbox and only click commandbutton1. I only see "Exit code: hello2". I do not see the second message.
Single step through the code, execution is done after the exit code.
I type "hello2", click the button and only the exit code runs. Click the button again, it does run.
I have an update where I am playing around...
This seems to be the direction that I need to go:
Please Login or Register to view this content.
Last edited by Rhudi; 08-29-2019 at 10:18 AM.
When the textbox is selected, if you click the button the exit event is triggered and show the message. At that time, the mouse click but the button don't receive the click because the message is showing.
You can experiment by tab out the textbox, when the message is showing, don't close it and try click the button. You can't click the button to run macro until the message is closed.
Try this to capture the entrance in to button control so you can re-trigger the click event
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks