Pass Variable Between Macros

แชร์
ฝัง
  • เผยแพร่เมื่อ 1 ต.ค. 2024
  • Pass variables between macros with VBA. This is how you do it. Article on my site.
    www.thesmallma...

ความคิดเห็น • 2

  • @trsammy432
    @trsammy432 2 ปีที่แล้ว

    How can you move them back and forth? I want one variable to go into one macro, run a calculation and spit out the output variable back into the first macro. Any insights would be appreciated!

    • @thesmallman
      @thesmallman  2 ปีที่แล้ว

      I could be wrong but I don't think that is possible. Your workaround would be to use the second macros result and perform the necessary actions after the result is held in memory. Please post for others if you have a better workaround.