Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change event
Can you have several different little routines run, say in some kind of
sequence or other, in the Worksheet_Change (ByVal Target as Range) Event. I am trying to get a better handle on how VBA works in Excel as versus in Access. Whew, lots of differences. Thanks for your input Joanne |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change event
I usually put the little routines in a standard module and then call them in
sequence from the Event code. -- Gary''s Student - gsnu2007c "Joanne" wrote: Can you have several different little routines run, say in some kind of sequence or other, in the Worksheet_Change (ByVal Target as Range) Event. I am trying to get a better handle on how VBA works in Excel as versus in Access. Whew, lots of differences. Thanks for your input Joanne |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change event
Yes you can do that. Right click a sheet tab, view code and paste this in
Private Sub Worksheet_Change(ByVal Target As Range) macro1 macro2 macro3 End Sub Sub macro1() MsgBox "This is macro1" End Sub Sub macro2() MsgBox "This is macro2" End Sub Sub macro3() MsgBox "This is macro3" End Sub "Joanne" wrote: Can you have several different little routines run, say in some kind of sequence or other, in the Worksheet_Change (ByVal Target as Range) Event. I am trying to get a better handle on how VBA works in Excel as versus in Access. Whew, lots of differences. Thanks for your input Joanne |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change event
Thank you, thank you guys
That clears up a mass of confusion in my head. I think I read somewhere in the forums or online resources that in Excell you should not use the "Call" command word when calling routines. I don't remember what it said the reason for this was, but am I correct in this? Thank you Gary''s Student wrote: I usually put the little routines in a standard module and then call them in sequence from the Event code. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change event
Absolutely not correct.
I always use Call, it helps me to instantly differentiate between my custom methods and the VBA built-in methods. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Joanne" wrote in message ... Thank you, thank you guys That clears up a mass of confusion in my head. I think I read somewhere in the forums or online resources that in Excell you should not use the "Call" command word when calling routines. I don't remember what it said the reason for this was, but am I correct in this? Thank you Gary''s Student wrote: I usually put the little routines in a standard module and then call them in sequence from the Event code. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change event
Using the Worksheet_Change as the control procedure you
can see below how several procedures can be run by the change event. If call is used, the arguments must be included in parentheses for passing to the procedure. Worksheet Module Proj Module1 XLM Module Pvt Sub WS_Chng() Sub A() Sub C() Sub 1() 'Run Sub B() A 'Calls Sub A B 'Calls Sub B Sub 2() 'Run Call C(arglist) 'Calls Sub C End Sub Here is the kicker: If you use either Call syntax to call any intrinsic or user-defined function, the function's return value is discarded. "Joanne" wrote: Can you have several different little routines run, say in some kind of sequence or other, in the Worksheet_Change (ByVal Target as Range) Event. I am trying to get a better handle on how VBA works in Excel as versus in Access. Whew, lots of differences. Thanks for your input Joanne |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change event
I don't want to mislead you there, The Sub 1 and Sub 2 are actually not
actual subs but are procedures as part of the Worksheet change Sub. "Joanne" wrote: Can you have several different little routines run, say in some kind of sequence or other, in the Worksheet_Change (ByVal Target as Range) Event. I am trying to get a better handle on how VBA works in Excel as versus in Access. Whew, lots of differences. Thanks for your input Joanne |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change event
So could you give me an example of how to use Call
Do I simply say Call SubName? Thanks a lot for your help Joanne Bob Phillips wrote: Absolutely not correct. I always use Call, it helps me to instantly differentiate between my custom methods and the VBA built-in methods. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change event
Yes, if the procedure has no arguments, it is simply
Call proc_name If it hasrgumnets, the values are passed in brackets Call proc_name(value1, "Text2") and if it is a function returning a value then any parameters are in brackets , using call or not myVar = my_func(param1, param2) or myVar = Call my_func(param1, param2) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Joanne" wrote in message ... So could you give me an example of how to use Call Do I simply say Call SubName? Thanks a lot for your help Joanne Bob Phillips wrote: Absolutely not correct. I always use Call, it helps me to instantly differentiate between my custom methods and the VBA built-in methods. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet_Change Event | Excel Programming | |||
Worksheet_Change event | Excel Programming | |||
How do I change a Worksheet_change event to a beforesave event? | Excel Programming | |||
Worksheet_Change event | Excel Programming | |||
Worksheet_Change Event | Excel Programming |