| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
Quote:
Check out the "OnEntry"function in VBA. This should allow you to run another macro which brings up your pop-up. Educo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation boxes, outputting a final number from the boxes | Excel Discussion (Misc queries) | |||
| Moving. Want to number boxes and inventory contents of boxes | Charts and Charting in Excel | |||
| Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
| Questions on combo boxes and list boxes. | New Users to Excel | |||
| How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
Hybrid Mode
