View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default help with variable

Lol. But in a standard module what use is it?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jamie Collins" wrote in message
om...
"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.

--