Basic Excel Macro Question

[04777867]

Hi

Am currently working on a excel sheet that i need a popup window to come up when i select a specific cell. I have tried creating a macro and can get the popup to appear with the correct information (in itself i feet of sheer wonder to me) however am trying to get the workbook to jump to another sheet if yes is selected or remain on the same page when no is selected. I am a macro virgin and have spent two days trying to work it out but to no avail. I need the blue title bar to say microsoft access and the wording to say "You will lose any changes entered on closing. Are you sure?" the no will keep it on the same sheet and the yes to jump to another sheet within the same workbook. I am graciously asking for someones help in generating the macro for this. I am using excel 2002.

Thank you in advance

Dan

 

[Burrgogi]

Just wanted to say a huge thank you to everyone who posted help and advice. I have now resolved this issue with you kind help. I am still a VB newbie and was wondering if anyone can advise on any decent websites/books to put me on the right path?

Thanks again

So glad you asked.

http://www.mrexcel.com/store/index.php

 

[04777867]

I like John Walkenbach's books:

http://spreadsheetpage.com/index.php/books/

Thank you Andrew for all your help you are a true gentleman and scholar.