ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how can i call sub or function in vba code (https://www.excelbanter.com/excel-discussion-misc-queries/96502-how-can-i-call-sub-function-vba-code.html)

xxx

how can i call sub or function in vba code
 
hi,
i request that how can i call sub or function in vba code

thanks


Bob Phillips

how can i call sub or function in vba code
 
Call mySub

or with parameters

Call mySub(val1, "Text val")

if it is a function

myVal = myFunc(val1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"xxx" wrote in message
ups.com...
hi,
i request that how can i call sub or function in vba code

thanks




Norman Jones

how can i call sub or function in vba code
 
Hi XXX,

i request that how can i call sub or function in vba code


'=============
Public Sub Tester()

'your code
Call MyMacro
'possibly more code

End Sub
'<<=============


---
Regards,
Norman



Norman Jones

how can i call sub or function in vba code
 
Hi Bob,

Apologies, I failed to see your earlier - and better - response!


---
Regards,
Norman





All times are GMT +1. The time now is 06:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com