User calculating a field

  • Thread starter Thread starter CAM
  • Start date Start date
C

CAM

Hello,

I want to have an unbound text boxes that the user can make a calculation
similiar to an Excel cell. The use will input the number and hit the enter
button to get the result. For example the use will input the following:
=5*5 and press enter that text box should display the number 25. Now I want
to use the following signs + - / * as well. How can I do this. Thank you
in advance.
 
You can use the Eval function. For more detail, see VBA Help.
You can't use the = sign, it will throw an error. You would use the
control's After Update event to do the calculation.
 
Back
Top