I have an Excel workbook with 1 active sheet, another one is very hidden. I have a userform which fills the labels from the title row in the visible sheet. Sometimes the title row happend to be overwritten by the user's inputs, couldn't find the reason.

To solve the problem I created a button to reset the titles in the visible Excel sheet - the titles were copied from the hidden sheet.

When the users change the titles how can I make sure that the changes are also written to the hidden page?

I think I would have to get the newly entered value and write it to the hidden sheet, but how can I get hold of the new value?

If Not Intersect(Target, Range("A3:Y3")) Is Nothing Then
    intRow = 1
    intColumn = Target.Row  
    strNewValue = Target          
End If

strNewValue gives me the old value, not the new one.