problem with input decimal numbers into a textbox

When i put decimal numbers into excelsheet de numpad . gives a ,
But when i put a decimal number into a textbox on a userform de numpad . stays a . en the number is a integer.

My settings are
language: Dutch
Keyboard: VS

Why is the input different in excel then in VBA ?
How do I have to configure VBA or userform so I can use de numpad . as a , ?

When inputting number into an Excel worksheet cell, Excel formats it as a number by default. However, when you type into a textbox, it is always considered to be text and will be exactly what you type. If you want "." to change to "," you can add code like this to the UserForm module. Change TextBox1 to your actual textbox name:

Please Login or Register  to view this content.