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?

Option Explicit

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


"MachAngle" wrote:

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?

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

eg

x= myvalue * 2



"Patrick Molloy" wrote:

Option Explicit

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


"MachAngle" wrote:

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?

Looks straight forward.... Thanks!

"Patrick Molloy" wrote:

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

eg

x= myvalue * 2



"Patrick Molloy" wrote:

Option Explicit

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


"MachAngle" wrote:

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?