¿como validar el contenido de una celda en excel?

[mrocf]

Hola! Coopérnico46.

Podrías intentar con:

Código vba:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, [e1:e100]) Is Nothing Then Exit Sub
 
If Evaluate("SUMPRODUCT( --ISNUMBER( SEARCH({""\"",""/"","":"",""%"",""'"",""~*"",""~?"",""<"","">"",""|"",""""""""}, " & Target.Address & ") ) )") > 0 Then
  MsgBox "Se ha introducido un caracter inválido..."
End If
End Sub
 

Saludos, Cacho.