Office 2007 and 2010 & VB6 issues Text Boxes

Hi All,

I having a slight issue with Text Boxes and I have never seen this error before.

This form is a DLL which is used by Excel The user Then Loads This Form up and put in the Numbers they require Say they want 4.2 they put that in but it changes it to 24 it removes the decimal Point and it does the same on the Cell in excel where they put the number. You can put the numbers in with decimal places fine in Excel and then when you load the form it will pick it up with the d.p. Why would this do this?
Any ideas how to fix it would be great!

Thanks in advance!

i assume this dll is from an external company and you have no access to the source code?
as there is no way to tell what is happening within the dll, you would need to refer it back to the writer of the dll

if the wrong result is always consistent, it may be possible to convert the values inserted into excel, using VBA in the worksheet change event