| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When content of a cell changes, content of another deletes
If a formulated value in A1 changes to any value after a value is
manually entered in B1, I need the content of B1 to be deleted. In other words, 1) A1 first reflects a formulated value, 2) a value is manually entered into B1, 3) input elsewhere causes A1 to return a different calculated value, 4) thus causing B1 to delete its input. Is there a simple macro that will accomplish this? Thanks in advance. Michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Content in one coulumn using given content in another | Excel Worksheet Functions | |||
| Deleting Rows - only deletes content | Excel Discussion (Misc queries) | |||
| cell automatically deletes content if cell is selected | Excel Discussion (Misc queries) | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
Threaded Mode
