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

I assume you are saying that you already have a worksheet_change event. You
should always post your code for comments. You can also have this. Perhaps a
restriction

if target.address="$A$2" then call subnamehere

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Howard" <(E-Mail Removed)> wrote in message
news:E89CBF41-13AC-42F6-971D-(E-Mail Removed)...
> 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

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

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

Post YOUR code


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Howard" <(E-Mail Removed)> wrote in message
news:ECE40553-9584-4868-9ED7-(E-Mail Removed)...
> 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

Don Guillett:
Sorry about posting the code. I ran out of time today. I'll try your
suggestion, and if I need to post again, I'll be sure and include the code
I'm working with. Thanks again for you assistance.
--
Howard


"Don Guillett" wrote:

> Post YOUR code
>
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "Howard" <(E-Mail Removed)> wrote in message
> news:ECE40553-9584-4868-9ED7-(E-Mail Removed)...
> > 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
>
>