View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default 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