Hide/Unhide text box based on cell value with real-time data from arduino

[art_a_game]

Hi! I need some help. I have a column in sheet 1 that have a real time data on it that comes from arduino and I want to hide or unhide a textbox on sheet2 based on the value of the cells in the column but everytime the arduino feed data to the cell nothing happens but when I manually enter data the textbox can now be hide/unhide. Please help! Here is my code:

Private Sub Worksheet_Change(ByVal Target As Range)


   If Target.Count > 1 Then Exit Sub
If Not Application.Intersect(Target, Range("Sheet1!B:B")) Is Nothing Then
        If Target.Value <= "40" Then
        
            ActiveSheet.Shapes("Text Box 1").Visible = True
        Else
            
            ActiveSheet.Shapes("Text Box 1").Visible = False
        
         End If
    End If
End Sub