Filtering for valid characters

[ElEdwards]

I use Excel spreadsheets for entering data for a character generator at my TV station (WKYC-TV, Cleveland). The result is a crawl of information at the bottom of the screen, like you see on CNN, FOX, etc.
Usually, this works with out a problem. The producers enter this crawl information into specific cells, which I have formatted to turn red if they enter more than 255 characters of information (mainly because that's about as much as a person can read before losing their place).
Here's the problem:
The character generator (by Chyron) accepts characters with a decimal value from 3 to 191 as valid characters. If the decimal value is higher, the data is interpreted as commands, ranging from changing the speed to terminating the crawl.
I want to filter each of these cells so that only acceptable characters are sent (decimal 3 to 191) and it must be done as soon as the producer hits Enter.
The range is F2:F500.

Thanks for any help

 

[ElEdwards]

Here is my version that finally works!!
==============================<pre>
Private Sub Worksheet_Change(ByVal Target As Range)

With Target
If .Column = 6 And .Row >= 2 And .Row<= 500 Then
Application.EnableEvents = False
NewText = ""
oldtext = Target.Text
If Len(oldtext) > 0 Then
For i = 1 To Len(oldtext)
If Asc(Mid(oldtext, i, 1)) >= 32 And Asc(Mid(oldtext, i, 1))<= 125 Then
NewText = NewText + Mid(oldtext, i, 1)
End If
Next i
Target.Value = NewText
End If

Application.EnableEvents = True
End If
End With

End Sub</pre>
_________________
El Edwards, the Voice of "You've Got Mail".
Go to http://www.makinwavs.com to order customized versions of the AOL (& non-AOL) wav files.
This message was edited by ElEdwards on 2002-09-12 14:34

 

[Jim North]

El,

If you put<pre> on the linebefore the code and</pre> on the next line after the code it makes it easier to ready (and copy and paste).

... you can go back into your last post and add them.
_________________
JRN

Excel 2000; Windows 2000
This message was edited by Jim North on 2002-09-12 14:28