G
Guest
Is it correct to refer to a Dim statement as a variable? See the following
macro and comments:
Sub ToggleInterestRate()
Dim Toggle As String
'Defines Toggle as a variable
Toggle = InputBox("Enter Y or N to toggle interest rate calculation")
'Defines the variable Toggle as equaling the value entered in the
pop up.
Worksheets(1).Range("A3").Value = Toggle
'Applies the value specified as Toggle in the cell A3
I guess what I'm asking is: is there ever a case where a Dim statement is
NOT variable; i.e., is a constant?
Dave
macro and comments:
Sub ToggleInterestRate()
Dim Toggle As String
'Defines Toggle as a variable
Toggle = InputBox("Enter Y or N to toggle interest rate calculation")
'Defines the variable Toggle as equaling the value entered in the
pop up.
Worksheets(1).Range("A3").Value = Toggle
'Applies the value specified as Toggle in the cell A3
I guess what I'm asking is: is there ever a case where a Dim statement is
NOT variable; i.e., is a constant?
Dave