Manual calculation with message box

[Donbozone]

Hi Everyone.

I would need a pieace of simple code which will be trigered by pressing Calculate Now button (manual calculation).

What I need after that is a message box with 2 conditions:

1. "Calculation successful" (if there is no cells with error on that sheet)

2. "Calculation unsuccessful" (if there is even one cell with error value - N/A, #Value etc.)

I believe this is possible since I already have message box after calculation is done, but I miss check on error values after that.

Thanks in advance

 

[Donbozone]

Wow, wow, wow, wow...this works beautiful

Many thanks for this, I really appreciate.