How to Bind VBA Variable to Range().Value2 Property

[MachAngle]

I want to use Excel VBA variables in modules and classes as "shorthand" for
the Range().Value2 property. I tried using declarations like:

Dim Variable As Double
Set Variable = Range("Cell Reference").Value2

Is there some way to use data binding in VBA to "link" a variable to a Named
cell property?

 

[Patrick Molloy]

Option Explicit

Public Property Get MyValue() As Double
MyValue = Range("Cell.Reference").Value2
End Property

 

[Patrick Molloy]

create the property, then use it in your code exactly as if it were a
'normal' variable

eg

x= myvalue * 2

 

[MachAngle]

Looks straight forward.... Thanks!

create the property, then use it in your code exactly as if it were a
'normal' variable

eg

x= myvalue * 2