Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the Call Statement
I have quite a few of the same set of coding in my Excel VBA. I have been
told, but cannot find any thing in the books that I have, about something called the €˜Call Statement. Can somebody explain to me or show me how this type of VBA code works. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the Call Statement
Sub FormatMySheet ()
SameOldRoutine 'goes to Sub name Do some other stuff End Sub Sub SameOldRoutine () do the same stuff End Sub By putting the name of a sub in another sub, code execution goes to the named sub, runs that code, then returns to the calling sub to finish it's code. Mike F "caldog" wrote in message ... I have quite a few of the same set of coding in my Excel VBA. I have been told, but cannot find any thing in the books that I have, about something called the 'Call Statement'. Can somebody explain to me or show me how this type of VBA code works. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the Call Statement
Lots of times, VBA's help is actually helpful. You may want to look there for
Call. caldog wrote: I have quite a few of the same set of coding in my Excel VBA. I have been told, but cannot find any thing in the books that I have, about something called the €˜Call Statement. Can somebody explain to me or show me how this type of VBA code works. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable in call statement | Excel Programming | |||
Call Statement and Return Value | Excel Programming | |||
using an if then statement call a caption box to a cell | Excel Programming | |||
using an if then statement call a caption box to a cell | Excel Programming | |||
Can you call a macro as in an IF statement | Excel Programming |