messagebox help

Hi
I need a help. I have a message box (Y/N) when i run a macro in my sheet1

I want the following to be happened..

If yes, I need to check the value in cell A1 of sheet2.
IF Sheet2 A1>0, then I need to type "error" in cell B1
else(if value of sheet2 A1=0) then type "ok" in cell B1

If message box answer is "No" then nothing to do ( select cell A1..)

please help me...
Thanku

Something like this?

Please Login or Register  to view this content.

Sure,

Where you have lines like this:

Please Login or Register  to view this content.

It should be:

Please Login or Register  to view this content.

Same applies for others where you are using the worksheet's name.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This might be what you want

Please Login or Register  to view this content.