Hi All,

I have an Excel sheet that does a bunch of calculations and takes about 15-20 seconds to complete the calculations. I have the excel sheet set to manual calculate so that it does not hang up on me as I enter data. Now, what I need is a pop-up window which pops up when the user clicks F9 alerting the user that the Excel sheet is calculating. Once the calculation is completed the pop up window can close.

I am newbie to VBA programming and any help in this regard will be appreciated.

Thanks,

AK