Hi there,

I need specific cells to update automatically, I currently have the following VBA:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target = Range("O34") Then
        Range("O38").Value = "O34"
    End If
    If Target = Range("O35") Then
        Range("O38").Value = "O35"
    End If
    If Target = Range("O36") Then
        Range("O38").Value = "O36"
    End If
End Sub
This is great, except I still have to double click on the cell (O34 / O35 / O36) to get it to actually update.

The cells mentioned are actually linked to different commandbuttons (these are doing what I need them to do).

The above code is on a sheet that will mainly be 'hidden', its where I keep all the formula's for the workbook so I can lock the sheet and hide it so no one messes it up.

Is there something I can include in the code to ensure the values are automatically updated as it's done so I don't need to double click on the cell before it works?

Thanks