Pop up boxes
 

I am creating a testing tracking sheet. Using conditional formatting. i have the fields set to color based on the entered result of the test. a 'P' wil mark the cell green, an F will mark it red, and so on.
what i am trying to figure out how to do, is if i mark a field with an "F" for failure. i would like a pop up box to appear asking for a bug # , or possibly a hyperlink.
I am a novice with Excel, but can understand complex instructions. can anyone help?

Hi,

Check out the "OnEntry"function in VBA.

This should allow you to run another macro which brings up your pop-up.

Educo