first of all Thanks to Fst1
I have recently created a macro, it works fine once when I execute selecting
Tools-Macro -Run.
I want the macro to be executed every moment I enter data, Instead of I
running this macro each & every time I enter the data.(i.e., results to be
displayed on the worksheet.)

Also How can I automate this process of opening this particular worksheet,
prompt user to enter data, run the macro and display the result.

Opening worksheet is once, calculating for different user inputs until user
says enough.

Pl let me know

Regards
--
reply to my posts are welcome