View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
TerryK[_2_] TerryK[_2_] is offline
external usenet poster
 
Posts: 16
Default More questions about variables and procedures...

Are the variables declared in the same Module or UserForm as the code that is refering to them
If not you might need to qualify them more strictly. for exampl

SomeUserForm General Declaration
Public SomeVariable as Intege

---------
Module

Sub SomeSub(
x= SomeUserForm.SomeVariabl
end su

I agree it seems buggy sometimes, I have found it best to be as explict as I can when calling variables and procedures. The small amount of extra typing gets rid of lots of unexplainable surprises

TerryK