UserFormulaRecognition
$30-100 USD
Paid on delivery
This is for an Excel macro.
I would like the capability to evaluate and execute user-defined formulas which are combinations of both defined field names and numbers.
Given a universe of fields, let's say A, B, and C, the user would input a desired formula:
(A+(B/c))/A * 2
I do not want to hard code the formula in VBA, because I want user flexibility.
The formula would be entered in a cell within a worksheet.
The code needs to
1) Read the cell and upload the formula
2) Evaluate the formula
3) Calculate
The output can be stored as a separate variable.
Assuming that the cell A1 is where the formula is entered, I have written the following sample code: Values for A,B,C are
defined in the code for test purposes:
A=1
B=2
C=3
Dim c As New [login to view URL]
Dim n As Double
Range("A1").Select
DynFormula = [login to view URL]
n = [login to view URL](DynFormula)
This routine works if, in cell A1, I enter a formula with numbers such as (5+1)/3.
This routine does not work however, if I enter variable names - A,B, or C - in cell A1; I get a Type13 mismatch error.
My problem is that I cannot get the Evaluate function to recognize variable names, even though their values are already defined.
There is a fixed universe of variables. For any one formula, only a maximum of five variables may be combined. So, it may be A+B+C+D+E, or it may simply be A.
Thanks
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
XP
Excel VBA (2000 or 2002)
If necessary , 2003.
Project ID: #3475584
About the project
14 freelancers are bidding on average $34 for this job
