Right click the sheets tab and pick View Code.
Use the Activate event to show userform

Private Sub Worksheet_Activate()

    frmUpdateInfo.Show
    
End Sub