Public WithEvents TextBoxGroup As MSForms.TextBox


--
Regards,
Tom Ogilvy


"Liedson31" wrote in message
...
thanks Bob

John Walkenbach's technique works fine and it's what i´m looking for...but
with textboxes!
instead of - Public WithEvents ButtonGroup As CommandButton
i put - Public WithEvents TextBoxGroup As TextBox

and it gives me an "object does not source automation events"
can you help me with this once more please.

thanks in advance
Miguel



"Bob Phillips" wrote:

Private Sub TextBox1_Change()
myCommonMacro
End Sub


etc., or else youy can modify John Walkenbach's technique shown here
http://j-walk.com/ss/excel/tips/tip44.htm

--
HTH

Bob Phillips

"Liedson31" wrote in message
...
hi everyone.

i have a function that i want to run everytime the user change a value
from
all textboxes included on a form. i don´t want to put code on every
textbox,i´m asking if is that any way that once the user input a value
on
one
textbox i run a function.have the forms a change event or similar that
let
me
do this?

thanks in advance
Miguel