Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'd appreciate some advice on when to use Run and when to use Call within vba. For example in Sheet1 the following code works fine and all the intended macros run when the relevant CommandButtons are pressed. However I need to understand when to use the Call statement and when to use Run. All I know at present is that use of Run requires "" and Call does not. Thanks, Mickey Option Explicit Private Sub cbo28Day_Click() Call sort28 End Sub Private Sub cboCritical_Click() Call sortCritical End Sub Private Sub cboEnterData_Click() Run "formNew" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wouldn't know what to call it! | Excel Worksheet Functions | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
call sub | Excel Programming | |||
How do you call one Sub from another Sub ? | Excel Programming | |||
call sub | Excel Programming |