R

Selecting celte willi lexl or formulas that are greater (hau fid diameters In length shall hide tire formula liar.

Mare than 911 formula characters here.

The quick brawn jumped mertliB I he quick brawn jumped over I ha The quick brown jumped over the The quick brawn jumped over the fax has lazy dog. fax has lazy dog fox has lazy dog fax has lazy dog.

More than 60 valus characters here.

The quick brown fox has jumped over 1 ha lazy dog. The quick brown fox has jumped over the lazy dog. The quick brawn fax has jumped aver the lazy dog. The quick brtwn fox has jumped ovsr the lazy dog. Tho quick brown fox has jumped aver the lazy dog. The quick brown fax has jumped aver the lazy dog. The quick brawn fax has jumped aver the lazy dog. The quick brewn fox has jumped ovsr the lazy dog. The quick brown fox has jumped aver the lazy d0C|.

Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub On Error Resume Next

If Len(Target.Text) > 50 Or Len(Target.Formula) > 50 Then Application.DisplayFormulaBar = False

Else

Application.DisplayFormulaBar = True End If End Sub

0 0

Post a comment