How to Pass Variables to Sub Routines

preview_player
Показать описание
In this video we demonstrate how to pass variables from one subroutine to another.This is a great solution to limit having to repeat variables within multiple routines as seen in our example.

#excel #vba #tutorial #msexcel #macros #visualbasic
Рекомендации по теме
Комментарии
Автор

I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content!

EssentialExcel
Автор

Excellent - very useful. I have always repeated variables in modular subs.
I also didn't realise 'Call' was optional.

lloydbelle
Автор

Thanks for the help. Very explicit. Video shows blurry but I've got the idea.

querrythis
Автор

You need to increase your zoom level on this video

kevincoleman
Автор

Nice video, but so over simplified that I don't think people will see the benefit. People could say that instead of modularizing the code like this, you could have added the 3 lines up above.

nicopicco