Re: Prevent Hard Inputs


Bob Umlas Wrote:
You can define a function to return true if it contains one of those
characters, then use conditional formatting in that range to turn cells
red
and reference the function, like
=SpecChar(A1) where A1 is the active cell when you use the conditional
formatting, and SpecChar is defined as:
Public Function SpecChar(rg) As Boolean
For Each thing In rg
If InStr(thing.Formula, "+") > 0 Or _
InStr(thing.Formula, "-") > 0 Or _
InStr(thing.Formula, "/") > 0 Or _
InStr(thing.Formula, "*") > 0 Then
SpecChar = True
Exit Function
End If
Next
End Function



Bob,

thanks, but how do I define a function?

KR


--
Frederik12
------------------------------------------------------------------------
Frederik12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32229
View this thread: http://www.excelforum.com/showthread.php?threadid=519791

.

Relevant Pages