Prevent User typing when Limit reached

Hello
I am new to the forum, but I am a seasoned user of Microsoft products.
What I am trying to do is use the Data validation (this part is easy) to reach a certain amount of characters in a cell. Then instead of the warning message displaying, I would like a hard stop. So the user would be prevented from typing or copy and pasting more information in the cell then the data validation is allowed.

I can find no thread that actually freezes or locks a cell when the data validation is reached.

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
    If Target <> Cells(1, 1) Then Exit Sub 
     
    If Cells(1, 1).Characters.Count > 55 Then MsgBox "A1 must not exceed 55 characters"
	And cells(1,1) = freeze. 
End Sub

I know that the And cell(cell reference is wrong and there is not a method or function for freeze. But hopefully this helps you understand what I am trying to do.
Thanks