Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I program in VBA to require that a user inputs a not (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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |