Userforms: Run same code when enter any textbox

Hi There,

i have 15 textboxes in my userform (all with tags).

instead of having 15 seperate sub routines that call on one macro is there a way i can write some code that, on entering any texbox within a form, a specific routine would be called

i tried using the Userform_click sub like so, but with no joy:

Please Login or Register  to view this content.

i appreciate any help on this

thansk for reading and for any help offered

cheers

Put the code into a Procedure in the Form module

Please Login or Register  to view this content.

Hi Roy,

yeah i know i can do that but that evaids the point of my question lol.

basically i'm trying to avioid writing the below for each textbox:

Please Login or Register  to view this content.

i'm looking for a snippet that on entering anytextbox within a form can call a specific macro, is this possible? in the end i'm merely trying to tidy up the code behind it all.

cheers for you swift original reply though

maybe you could adapt the Class module used in my Calendar Form

Normally I would say use a class, but that won't work for the Enter event of a textbox unfortunately, so I think you are out of luck.

That answers my suggestion

How do you know a class module wouldn't work for the Enter event of a textbox? and also what event's would it work for!

cheers guys

Originally Posted by Macdave_19

How do you know a class module wouldn't work for the Enter event of a textbox?

because I'm clever?

and also what event's would it work for!

BeforeDragOver
BeforeDropOrPaste
Change
DblClick
DropButtonClick
Error
KeyDown
KeyPress
KeyUp
MouseDown
MouseMove
MouseUp


basically every event that isn't inherited from the base Control class (and unfortunately although you can declare an MSForms.Control variable WithEvents, which would give you the Enter event, you can't then assign your actual control to the variable!)