excel calculation using function formula in userform

sorry my last question is in texbox 8 i want to add the code for currency as you provide me 1st

Private Sub TextBox8_Exit(ByVal Cancel As MSForms.ReturnBoolean)

Me.TextBox8.Value = FormatCurrency(CCur(Me.TextBox8.Value))

End Sub

i want to see the result in the time when i enter the final result

ok i did it , thanks for your great support roy.

yes roy the formula is work now .

now i am trying to send those data in my excelworkbook as a database.

thanks

ok thats' sound great .