| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want a yes/no prompt before changing data in cell
Before a user changes data in a cell I want a text to opening asking if they
are sure they want to change the data. How do I go about this? The data can be variable so validation won't cover it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Want a yes/no prompt before changing data in cell
Actually, I think Data Validation may be exactly right for your situation...
Select the cells From the Excel main menu: <data<validation <settings tab Allow: Custom Formula: 10^99 <error alert tab Style: Warning Title: Please Verify Error message: OK to change the value? With that method, the error alert will display for virtually all entries, but since the style is Warning...it will allow the new entry. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Phil" wrote: Before a user changes data in a cell I want a text to opening asking if they are sure they want to change the data. How do I go about this? The data can be variable so validation won't cover it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro question | Excel Worksheet Functions | |||
| how can I connect data in cell C to data in cell D? | Charts and Charting in Excel | |||
| cell data changing when a value within a group is changed | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Splitting Data in a Cell | Excel Worksheet Functions | |||
Linear Mode
