| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When a value is changed manually or dynamically in a cell, how can I tell?
I have been using the following to monitor for changes in cells in my excel spreadsheet:
Private Sub Worksheet_Change(ByVal Target As Excel.Range) But I am unsure if this monitors manual key entry, as well as automatic changes to cells (if I manually modify F1, and the values of F2, G3, h56 and i44 are based on F1, they will get modified). Can someone tell me if I am wrong or right? And if I am wrong, what can I use that will monitor for both automatic changes to cells and manual changes to cells? Thank you. Doug |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| manually selected Excel cell formatting | Excel Discussion (Misc queries) | |||
| Cell keeps the formula even after changing the value manually | Excel Discussion (Misc queries) | |||
| Format changed when the details in cell changed | Excel Worksheet Functions | |||
| Make manually changed pivot table column headings work for other u | Excel Worksheet Functions | |||
| Manually reseting the used cell range | Excel Discussion (Misc queries) | |||
![Doug[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
