difficulty with SetFocus in data validation for textbox

[kuraitori]

Hello All,
Thought I would ask for your expertise on this question as you all have been so helpful with other ones.

Trying to have a format validation for a Registration Date Textbox

What I am trying to do is have the cursor return to the textbox (similar to "stop" error alert when adding data validation to a cell)

I've tried Textbox1.SetFocus
and TextBox1.Activate
and TextBox1.Select

None of these work, please advise as a person could click "okay" on the msg box and proceed, leaving the date box blank.

Here is my code as it stands

Please Login or Register  to view this content.

[rylo]

Hi

Haven't met up with numericformat. What version of Excel are you using, or what is the function code?

rylo

[kuraitori]

I am using Excel 2002 with Service pack 2

I would actually like to lose the NumericFormat part.

What I was trying to do with that was stop the textbox from ignoring non-numeric value

with the current code, I could type in "noon" and it would be fine. I was trying to force the hh:mm format. Any idea how to get it to apply to non-numeric data too? Also have one for date.

[royUK]

Is NumericFormat a User Defined Function?

Try this, change the TextBox name

Please Login or Register  to view this content.

[kuraitori]

how do I get it to accept the / separator?