UserForm number pad decimal separator

I’m currently using this at for the number key pad on the UserForm and the decimal point works

Please Login or Register  to view this content.

I can across this that just seems more concise but I can’t get the code right for the decimal button,
getting RunTime error 13 – type mismatch

Please Login or Register  to view this content.

You call function and pass String as parameter

Please Login or Register  to view this content.

But your function expect to get Integer as parameter

Please Login or Register  to view this content.

Sorry Kasan your talking to a Vba numskull here my grasp of it is limited to say the very least.

How do I get the number as an Interger rather than as a String?

Change "Integer" to "String" here

Please Login or Register  to view this content.

Thanks Kasan

Like I said, limited grasp!!