Sample calculation Macro with dynamic validation

[sesgiri]

Hi Techies,

Need your help in getting my issue solved. below is my requirement, i am done with step 1 and struggling to give symbols for D3. Please have a look at the attached sheet and kindly do the needful

* Only numbers can be entered in cells B3 and F3. If other values are entered error should be shown.
* D3 can take only one of the following values: + (or) - (or) * (or) /. Error should be shown if any other value entered.
* Depending on the operator specified the calculation should be done and result should show in cell J3 when 'Calculate' is clicked.

 

[chirayu]

refer to

https://www.vertex42.com/ExcelArticles/evaluate-function.html

 

[sesgiri]

Thank you Chirayu

 

[sesgiri]

Not so useful due to references and i need them in Macros. Please do the needful

Thanks!

 

[NARAYANK991]

Hi ,

See if this is what you wanted.

Narayan

 

[sesgiri]

Splendid Narayan. Topman, thank you for your support!