How to use variable of one function in another function in vba?

Question

I am facing one small problem please help me.

sub vari()
dim b as integer
dim c as integer
b=6
c=8
end sub

now i want to use b and c in another function .

sub calculate()
dim a as integer
a = c+b
end sub

I am getting error here

Does this answer your question? How do I declare a global variable in VBA? — TylerH
– TylerH, Commented Feb 22, 2023 at 22:39

user1726343 · Accepted Answer · 2012-10-08 09:25:03Z

8

You want to use the proper scope for your variables. If you want for b and c to be accessible to both vari() and calculate() you need to declare them globally, like so:

Public b As Integer
Public c As Integer
sub vari()
....

answered Oct 8, 2012 at 9:25

user1726343

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use variable of one function in another function in vba?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related