data validation

[hawley]

In a cell I have data validation that only a X can be entered. The wierd thing is that I can enter in an "*" or "X" and it accepts it. Although it should not accept the "*". One more wierd thing is that it will accept a "X*" or a "*X". Does anyone know why this is?

 

[IML]

if you're just using list with a plain and simple x in the source box, this should not be happening. You're not pasting (as opposed to typing) this in, are you?
This message was edited by IML on 2002-05-02 13:49

 

[hawley]

I am using a list and all I am doing is typing it in, not pasting.

 

[IML]

I'm stumped then. I was thinking if you were using a formula under custom as opposed to a list, you may run into some problems as the asterick is a wildcard character. At least you've ruled two things out... good luck

 

[inarbeth]

Can't replicate in Excel 2000. Which version are you using?

 

[sen_edp]

Hello Hawley

I tried it in excel 2000 and , yes it happens.
Maybe the * is a kind of wild character and excel ignores validation
I will work on it more

Andreas

 

[hawley]

I'm using Excel 97.

 

[Legacy 98055]

The change event will refuse anything but an X in cell A1. Edit to the correct address...

<pre>
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
If Not Target = "X" Then
MsgBox "Please enter an 'X'", , "Invalid Entry"
Application.EnableEvents = False
Target.Select
Application.EnableEvents = True
Exit Sub
End If
End If
End Sub

</pre>
Tom