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.

[Tom Schreiner]

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

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

Tom