Hello, so I am looking to find a way to have two cells from separate worksheets link together such that when either one is changed, the other one updates. I figured this out with the help of this forum by using this code:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim sh1 As Worksheet, sh2 As Worksheet
Set sh1 = Sheet1: Set sh2 = Sheet2
If Target.Count > 1 Then Exit Sub
Application.EnableEvents = False
If Sh.Name = sh1.Name And Target.Address = "$A$11" Then
sh2.Range("$B$18") = sh1.Range("$A$11").Value
ElseIf Sh.Name = sh2.Name And Target.Address = "$B$18" Then
sh1.Range("$A$11") = sh2.Range("$B$18")
End If
Application.EnableEvents = True
End Sub
Now this works fine, however there is another layer I am trying to solve now. I am trying to use multiple fonts within a cell, specifically attempting to use a font called "isoqsymbol" for specific symbols and just use "arial" for numerical values. My problem is whenever I change a numerical value or symbol, the linked cell in the other sheet updates in just plain "arial" font, leaving the symbol font out and making the cell illegible. Is there any way to keep font formatting linked along with the value? Please let me know if this is possible - or will I have to separate cells. Thank you so much.
Bookmarks