I need to know if there is a way to evaluate a Userform.textbox entry as a formula? For example, for a length field in a Userform the customer could enter 24 or 12*2 and either way it would evaluate to 24. Entering =12*2 would also be acceptable. I just would like for them to be able to use the input field to do calculations for convenience. I would like to be able to do this without putting the data as a string into a cell and then evaluating it. It would be preferable to "evaluate" it right within the VBA code. Thanks in advance for any help!
Bookmarks