View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default change value on a form

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