G
Guest
Hi All
I am delving into VB and getting somewhat lost. I have a spread sheet
designed so a end user only needs to enter columns of data and a few
parameters. However, the way it falls together is that I need to concatenate
text and evaluate the string as a formula. In a previous posting I found this
suggestion...
Sub ConvertToFormula()
ActiveCell.Formula = ActiveCell.Value
End Sub
I entered it into the VBA editor (as a UDF), and it appears in the user
defined function list. However it returns the #VALUE! error. I am more
familar with matlab and the comparative function in that environment would
be...
x = eval(concatenate('formula', 'as text'))
Thanks in advance
Nick Flyger
I am delving into VB and getting somewhat lost. I have a spread sheet
designed so a end user only needs to enter columns of data and a few
parameters. However, the way it falls together is that I need to concatenate
text and evaluate the string as a formula. In a previous posting I found this
suggestion...
Sub ConvertToFormula()
ActiveCell.Formula = ActiveCell.Value
End Sub
I entered it into the VBA editor (as a UDF), and it appears in the user
defined function list. However it returns the #VALUE! error. I am more
familar with matlab and the comparative function in that environment would
be...
x = eval(concatenate('formula', 'as text'))
Thanks in advance
Nick Flyger