Variables in VBA
A while back someone helped me write this code. Basicall someone inputs a
text string like '4+5 in cell A2 and in another cell you type =qwerty() and
the result is 9 (for the example given anyways). How do I change the formula
to accept a cell reference. For instance I want it to be =qwerty(F4) to look
at the text in F4.
Function qwerty()
Dim s As String
s = Cells(2, 1)
qwerty = Evaluate(s)
End Function
|