Declare variable memory allocation VBA

Question

When we declare a variable or instantiate an object in VBA, is the memory that is allocated in the RAM memory, Cache memory or ROM memory?

Jean-François Corbett · Accepted Answer · 2014-02-01 19:46:58Z

1

It's in the RAM.

ROM means Read-Only Memory, so obviously you won't write there.

As far as I know, VBA doesn't decide what goes to cache and what doesn't.

answered Feb 1, 2014 at 19:46

38.7k30 gold badges144 silver badges192 bronze badges

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

1 Comment

Thank you very much i was suspecting it but i needed someone who was not in beginner mode to verify also.