View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark[_36_] Mark[_36_] is offline
external usenet poster
 
Posts: 39
Default Assignment by reference or value

Hi NG

I have a question about assignment of variables by reference or value.

I have a module where a collection C is defined as public.

In my form i want to use that information. Because i use a callback e.g.
button_click() i can not parse C in to the function. Instead i do the
following in the button_click() callback

dim A as collection
A = modSomething.C

Is A then a copy of C or is it a reference?
For performance reasons i would like it to be a reference.

Regards
Mark