View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default help with variable

"Bob Phillips" wrote ...

You can create a variable of module scope outside of a procedure, but you
can only access it from within a sub or a function.


Option Explicit

Private m_lngValue As Long

Public Property Get Value() As Long
Value = m_lngValue
End Property

;-)

Jamie.

--