worksheet.change

I am trying to auto populate cells in column "R" based on the value in column "A". So if cell "A8" = "ABC" then cell "R8"= "XYZ". If cell "A8" is cleared then cell "R8" is cleared too. I have a dropdown data validation list in Cell "A8". My code is working halfway but gives me a couple of...

I'm trying to convert below code from sending webhook when change done manually to when cells on the specific worksheet has been updated by formula, but without success. I was trying to change "Private Sub Worksheet_Change" to "Private Sub Worksheet_Calculate" with many variations of the code...

Hello How to prevent Redo and undo from being disabled in worksheet.change vba?

Hey there guys, I am trying to get this worksheet_Change to work correctly for what I need. I am pretty tired so I am probably not thinking straight. I have a drop-down list in column F, known as Status, it allows me to select a Pending, Pass, Fail, or leave the cell blank as the input. In...

hi all I've got multiple worksheets in one s/s and have created a worksheet change event in one and cant find a quick way of applying the code to the sheets? is it actually possible? or a simple paste/copy? Thanks

Hi all, I am working on an Excel 2010 workbook and am looking to create a worksheet.change event to hide specific rows if they are blank, or show them if they are not. I have a number of tables which use formulas to populate cells based on values elsewhere in the workbook, which means...