function to deal text with number together in textbox on userfrom after sum

[MKLAQ]

Hello,
I'm not sure if what I ask for it , is it possible !
so I have number format & text in first digit , the second digit will be space in textbox15 like this
ATRB 1,000.00 and textbox16 will be like this ATRB 15,000.00. so what I look for when sum textbox15+textbox16 then textbox17 will be like this " ATRB 16,000.00 "
I have VAL function but it's useless in this case.

TextBox17.Value = Val(TextBox15.Value) + Val(TextBox16.Value)

any function to deal with this case guys?

 

[JEC]

TextBox17 = Split(TextBox15)(0) & " " & Val(Split(TextBox15)(1)) + Val(Split(TextBox16)(1))

 

[MKLAQ]

Hi,
it doesn't show correct result in textbox17
example: textbox15=ATRB 1,000.00 , textbox16= ATRB 1,000.00
then the correct result will be ATRB 2,000.00 .
based on your code will be =ATRB 2 !

 

[JEC]

Because you have a comma in your numbers, which is not a thousand separator in your case

 

[MKLAQ]

this is until make easy to read numbers . so there is no way to solve this problem?

 

[JEC]

yes you have to write your numbers differently, so don’t use a comma as thousand separator. Use a dot instead. Comma for decimals

 

[MKLAQ]

bad news buddy!
thanks for inform me.

 

[JEC]

How is that bad news

 

[MKLAQ]

How is that bad news

you said

yes you have to write your numbers differently, so don’t use a comma as thousand separator. Use a dot instead. Comma for decimals

I expect you're talking about this

and use comma as I said

this is until make easy to read numbers

and I try to change your suggestion by use replace function and this is what I got

TextBox17.Value = Split(TextBox15)(0) & " " & Val(Replace(Split(TextBox15)(1), ",", "")) + Val(Replace(Split(TextBox16)(1), ",", ""))

and what I want

now I face problem in textbox17 should show #,##0.00