Update Multiple Labels on Sheet when Corresponding Cells on another sheet are updated.

[Krakenfan69]

Hi guys,

I am kludging together some vba on a sheet and could use some help. I have several Labels on Sheet1 that I would like to update if the corresponding cells on sheet 2 are updated. I have the following code figured out to work for the first one but when I added the code for the others they didn't work. Sadly my labels are no in numerical order either.

Private Sub Worksheet_Change(ByVal Target As Range)
Sheet1.Label51.Caption = Sheet2.Range("B40")
Sheet1.Label50.Caption = Sheet2.Range("F40")
End Sub

So adding the same code again or trying to place the references all between the Private_Sub and End Sub didn't work either.

Thanks for any help,

Kraken Fan #69

 

[Krakenfan69]

Update: I'm an idiot. It wasn't working because I was pushing the data into the wrong Label tags. I was able to group them all under the Worksheet_Change header and they are working fine. Sometimes just talking through a problem helps you work it out.

Thanks,

Kraken Fan #69