title: excel 4.0 macro evaluate
body: <p>I am trying to evaluate an equation in Excel where the operation is determined by the value of a cell. For example, let's say I have an equation in <code>A2</code> that says <code>100 (operation) 100</code>. I want that cell to be evaluated such that <code>if A1 = 1, then 100*100, if 2 then 100/100, if 3 then 100+100, if 4 then 100-100</code>. I was able to come up with a solution using <code>VLOOKUP</code> to determine the operation, concatenate to combine the numbers with the operation, and Excel 4.0 macro function EVALUATE in a named range to evaluate the text string as a number. </p>
  
  <p>Now, I'd like to do the same thing in VBA (I still have the operation lookup chart, ie <code>1 = *</code>, <code>2 = /</code>, etc. in Excel sheet). Is there any way to do this without if/then/else statements?</p>