View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
chfa chfa is offline
external usenet poster
 
Posts: 14
Default VBA passing information between differnt User Forms


Hi John,

thank u 4 your answer. Of course theres no point
in using global variables. That's a kind of dirty hacking ;-).

Your hint signing the variables with "m_" seems a
valuable practice worth adopting.

But last not least. The knack of the problem is covered
in Keith75's comment. Using UF<Nbr_Intialize
runs into a deadlock, as each module tries to initialize
the variables .... Using UF<nbr_Activate works.

And by the way. Why String? Ok. That's a historical
try. I changed to boolean, the most suitable Type for
this kind passing states.

Thanx a lot, happy easter, so long, vbr

chfa