Restrict Textbox entry

[pauluk]

Hello all

My mind is blank and i need a little help

With the text box in a vba form can you restrcit the values a user can enter.

If the use types a character then nothing appears only when they type a number it appears.

I don't want it to validate using a command button just to restrict what a user can enter.

Thanks in adavnce

[cbanks]

this option is in the properties window of the object.

[pauluk]

Not sure where this property is as it does not appear in the properties table

[pauluk]

I should be a bit more specific.

when the use goes to typ a character into the text box nothing happens, but when they type a number it appears

[royUK]

Normally I would use the TextBox_Exit routine

Please Login or Register  to view this content.

[stevebriz]

PaulUK,
Here is the code I put in the textbox keydown event and the correxpoding function.
There are a number of options to ht functions so you can configure it do do what you want
HTH
Steve

Please Login or Register  to view this content.

and the function:

Please Login or Register  to view this content.