Post YOUR code


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Howard" wrote in message
...
Thanks to both. I'm kind of new to VBA, but these ideas will help a lot.
I'll give them a try.
--
Howard


"Mike H" wrote:

Hi,

yes you can do that

worksheet code
Private Sub Worksheet_Change(ByVal Target As Range)
mysub
End Sub

and in a general module
Sub mysub()
MsgBox "Hello world"
End Sub

Mike


"Howard" wrote:

Question for all you guru's. Is it possible to put a VBA sub routine
in a
module, and then write a sub on sheet(1) that calls the module sub? I
have a
sub routine in a module which works when run manually, but I really
want it
to work when ever a cell on sheet 1 is changed. I already have a sub
routine
on sheet 1 now.
--
Howard