Type mismatch problem

Hello guys,

I'm just start studying and I have an exercise to do in VBA, so I'm a newbie in that
I have faced a problem, that the operation can't be made cause of problem "Type mismatch", screenshot is added to this topic.
Basically, I need to calculate wage after taxes, but probably because of the one result in formula with dot (.) in stead of comma (,) I can't get the result.
I already tried to surf the internet, but probably I'm finding it in the wrong way.

What I need to do to get this formula alive?
Thank you in advance!

Private Sub apr1_Click()
socnn = brutal / 100 * 10.5
socnd = brutal / 100 * 23.59
urvn = "0,36"
If combo.Visible = False Then
iin = brutal / 100 * 23 - socnn / 100 * 20
ElseIf brutal >= 1667 Then
iin = ((1667 - apsum - neapl - socnn) / 100 * 20) + ((brutal - 1667) / 100 * 23)
ElseIf (brutal - apsum - neapl) > 0 < 1667 Then
iin = "(brutal - apsum - neapl - socnn) / 100 * 20"
Else
iin = 0
End If
neto = brutal - socnn - iin
End Sub

problem.pngBDAT_MD1_- Copy.xlsmBDAT_MD1_- Copy.xlsmproblem.png

Hello @zoox.
Maybe, I'm not sure. Try:

Please Login or Register  to view this content.

For a more detailed understanding of your problem, please make a small example file and attach it to your starting post. And what are your operating system regional settings, "," or "." (delimiter)?

Hi from Ukraine!

I'm not seeing an error in the Copy.xlsm workbook uploaded in post #3 so am not sure what is the cause.

Just by way of information, a "Type mismatch" error means that the value of some variable calculated by the code isn't matching the 'required' type. For example, if the code is expecting a variable value to be an integer value but the variable is actually a decimal value or a string value, that can throw up a "Type mismatch" error. Excel VBA tries to handle this type of thing by- for example- converting an apparent string to a numeric variable but sometimes it doesn't always succeed/ can't use the current value of the variable.

I used a value of 700 in the 'brutal' text box (this object typically returns a string ["700" instead of 700] but your code converts it to a double so it's not clear to me what is causing the problem. It could be some 'internationalisation' issue as Mike suggested- maybe using a decimal point instead of a comma or vice versa (so 725.50 instead of 725,50, for example) is at the root of the problem but it was all OK on my laptop whichever value I used so long as the entry in the first textbox (brutal) is typed in as a genuine number rather than a string.

del
duplicate post, Sorry.

Good day @zoox. How did you solve your problem? Thank you for the reputation point! Peace and Health!