| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using VBA to make a user input a note when making changes to a cel
How can I program in VBA to require that a user inputs a note (I want a blank
note to pop up) when they change a number in a cell? For example, if I have cell B10 = 1,500 or =trend(B1:B9,A1:A9,B10:B20) and someone decides to type in a different number into cell B10, I want Excel to first open a pop up window asking 'What is the reason for the change?", second not allow the person to continue until they input a reason in the pop up box and finally save the note in the cell for future users to read. Thank you. Adam |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation note to comment note | Excel Discussion (Misc queries) | |||
| Prompt user for input and utilize that input | Excel Worksheet Functions | |||
| Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
| Sort Without User Input | Excel Discussion (Misc queries) | |||
| How do I make note cards from an inventory in excel? | Excel Discussion (Misc queries) | |||
![Adam Ronalds[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
