To type negative value in textbox (Userform)

It looks like you have something like this in the KeyPress Event of the textboxes:

If KeyAscii.Value = 45 Then KeyAscii.Value = 48

45 is the KeyAscii Value for "-" and 48 is for "0". Remove that line and it should solve it.

Good morning

This is very interesting! Will the "45" enable the use of both a "-" and a "+" in one textbox?

I created the userform myself and there is no such indication in the code, but I will try your code to enable the textbox to accept a negative value.

Regards
Anéll

Each (almost) key pressed on the keyboard has an ascii value attached to it. You can play with the result produced by pressing each key by assigning a different ascii value or do nothing by assigning a 0 to it.

However, if you have created the userform yourself and have not written any code specifically change the behaviour of a key, I am not sure why it would automatically behave differently.

Two possibilities I can think at this hour of the day (haven't slept for 2 nights):
1. There is problem with your keyboard
2. I have totally misunderstood your definition of "Userform" and "Textbox"

Oh by the way, the KeyAscii for "-" is 45, for "+" is 43, for "0" is 48

Well, having no sleep for 2 nights may be a bit hard on anyone I guess! Although I will not be able to function at all if I was in your shoes!

The information you gave me is however very interesting - I am rather green still where it comes to VBA coding and it is the first time that a user has the specific need to be able to type a negative value into a textbox used in the userform.

I will play around with the info that you gave me and see whether it helps or not.

Hope you get some rest soon ..!

Regards
Anéll

Hi!

I came upon the following code and it seems as if it is doing the job:

Selection.NumberFormat = "-0.00,0.00"

Thanks anyway for your help!

Regards
Anéll