Hello,
yes, it is possible to use Worksheet_Change event to monitor specific cells and do things when the cells are edited. I don't quite understand what you want to achieve, though. Could you step back and explain the bigger picture?
As far as I understand it, the requirements are like this:
- if A4 is empty, cell "X" should be blank.
- As soon as a value is entered in A4, cell "X" should show 0.
- The user should be able to enter a value into cell "X", overwriting the 0
- when the value in A4 is deleted, so A4 is blank again, cell "X" should be blank again as well
The following Worksheet_Change Event performs this. Cell "X" in this case is B4, which is an offset of 0 rows and 1 column starting from A4. Change the offset to suit your needs
The attached file has the macro installed. Play around with the values in A4 and B4 and see if that is what you need.
Does that give you a starting point?
If you need to enhance this and get stuck, please pipe up. Clearly formulated requirements will help find a solution faster.
cheers,
---------------------
Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:
Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste
Bookmarks