Userform Textbox - Capturing Mouse Click

**CraigsWorld** · 04-07-2015, 12:24 PM

Hi there again!
I have a userform with many textboxes (105) that currently when I enter one or two numbers and press "Enter" a generic procedure is run via the "KeyDown" event, manipulating the numbers entered. The problem I am having and am not sure how to fix is; if the user mouse clicks on another textbox without hitting "Enter", the focus changes to the new textbox without firing the "KeyDown" event from the previous textbox. Currently I am using a "KeyDown" event only to trigger my procedure.

How can I make better use of the events by picking up both the "EnterDown" and the left mouse click.

Here is a sample of my code:

Please Login or Register  to view this content.

Thanks Craig

**mehmetcik** · 04-07-2015, 12:53 PM

Hi.

Firstly with that many text boxes I would use a subroutine to handle my text boxes

I then use a macro to create my textbox events in excel and copy paste into VBA.

Secondly I would do the same for the mouse down and textbox enter events.

Start of by declaring T as a global variable.

this is the sort of code that I use:-

Please Login or Register  to view this content.

ConEnter, ConChange and ConExit are my three subroutines and they work for all my text boxes.

So clicking t is your existing text box, clicking on textbox2 will trigger the textbox1 exit sub ie ConExit and then run the textbox2 entry sub ie ConEnter.

My Macro for creating the textbox vb code is quite simple.

bear with me and I will modify it to create your 105 x 5 macros.

Clicking on the button in the attached file will create 525 macros for you.

Then all you need is 3 subroutines.

Now that you have your textbox events trapped all you you to do is write the subroutines.

Please Login or Register  to view this content.

Modify hange_SpecialHours and next_SPtextbox to use T as the textbox number.

you can use something like

Please Login or Register  to view this content.

**CraigsWorld** · 04-09-2015, 12:22 AM

I ended up having trouble with the event firing order. The mouse click fired on first click and I ended up with strange results. I decided to make some changes and used comboboxes instead of textboxes which made my code run much more efficient. This way my code always fires correctly and I can force the user to choose the items available.

I did love the macro for creating the events codes... could have used that 10 years ago... all the editing I have done in the past would have saved me lots of time.

Craig