View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default **Pop-up message prompting for user information**

This may be tricky, but I hope it can be done.

I'm looking to create a pop-up box that when a user overrides a formula by
entering a "hard" number a pop-up will appear. Once this pop-up appears I
would like it to ask for

User name:
Reason for Override:
Date:

I'm pretty sure this is all possible. The real trick then comes into play
next. What I want to do with this information is have it stored there so
that when i click on a cell that has been overriden it will pop-up with a box
that tells me who overrode it and all the other above information.

I am new at writing code, I have just started exploring this world earlier
this week and any help/suggestions will be greatly appreciated.

Thanks!

Steve