Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
Using variables . . . | Excel Discussion (Misc queries) | |||
How do I Sum variables | Excel Programming | |||
Variables | Excel Programming | |||
Variables | Excel Programming |