UserForm - adding exception to text box restrictions (numbers only)

[DHFE]

I've found the below code which will prevent anything other than numbers being entered into the text boxes within my userform. However this means that a negative (-) symbol cannot be used. Is there any way I can keep the restriction but allow the negative symbol to also be used?

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[antoka05]

The code that you attached allows to use negative numbers because, for instance, 3 or -3 are both numerics and the code allows a numeric value.

If you need you could also prevent to digit alphabet characters using the Keycode event of your control... for example, if your control is TextBox1 you can use this code:

Please Login or Register  to view this content.

This are codes that I used:
8 backspace, 35 End, 36 Home, 37 left arrow, 39 right arrow, 46 Canc, 109 '-', 96 to 105 is char from 0 to 9.
Regards,
Antonio

[DHFE]

Thanks Norie that code worked.

antoka05 - the code I posted doesn't let me enter negative numbers. The second I type '-' I get the message box pop up telling me I can only enter numbers.