Command to omit first number not the best choice?

Hi ,

I recently has some code whereby a TextBox would display a number without the first digit. So, 3.456 would be displayed as .456 which allowed the textBox to make a certain calculation.
However, sometimes the number 12.214 would be displayed and of course I need .214 but the TextBox is displaying 2.214. So I need code that will display any number including and after the decimal point?

Can anyone help as to how this line can be adapted?

TextBox8.Value = Right(TextBox5.Value, WorksheetFunction.Max(Len(TextBox5.Value) - 1, 0)) 'THIS DISPLAYS THE FIGURE WITHOUT THE FIRST FIGURE e.g. .25454

Many Thanks

Got a Syntax error?

Thanks, I'll give it a go Cheers

There's a misplaced bracket, but (as in the code in your image), you should use the VAL() function to ensure you are working with real values

TextBox1.Value = Val(TextBox1.Value) - Int(Val(TextBox1.Value))  '// Or whatever textbox number it is

I've put this but got crazy values?

Old code gives me 0.569 (which is correct) but the code:

TextBox1.Value = Val(TextBox1.Value) - Int(Val(TextBox1.Value))

gives me -36.431?

Ideally, I'd like the code to take a number from the decimal point onwards. That was it won't matter how many digits are before the decimal point because the code will ignore them all.For example, the figure 123.456
will be .456, if the figure is 12.456 it will still be .456 and if the figure is 3.456 it will still be .456.

??

Did you note the comment about "whatever Textbox number it is"???

Sorry, it does work fine, I missed the last Text Box:

TextBox8.Value = Val(TextBox5.Value) - Int(Val(TextBox1.Value))

Thank you very much ;-)