View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams[_2_] Tim Williams[_2_] is offline
external usenet poster
 
Posts: 298
Default Create own properties?

Dim m_URL as string

Property Let URL(val as String)
m_URL = val
End Property

Property Get URL() as String
URL = m_URL
End Property


Tim

"Charlotte E" <@ wrote in message
...
Yes. Eg: enter this in the "ThisWorkbook" module in the VBE:

Property Get URL() As String
URL = "http://www.google.com"
End Property



Is it possible to do the opposite?

I.e.: ThisWorkbook.URL = http://www.google.com/

...so it can be read later with:

MsgBox ThisWorkbook.URL


???