Hi,

I'm trying to add up and calculate 4 textboxes into a label.

This is how it should work:

First action:
TextBox1 + TextBox2 + TextBox3 + TextBox4 = "TOTAL"

Second action:
if "TOTAL" is equal or smaler than 4.99 == Label1 = 0
if "TOTAL" is between 5 and 9.99 == Label1 = 1
if "TOTAL" is between 10 and 14.99 == Label1 = 2
if "TOTAL" is between 15 and 19.99 == Label1 = 3
if "TOTAL" is between 20 and 24.99 == Label1 = 4
if "TOTAL" is equal or bigger than 25 == Label1 = 5

I would like to put the two actions into one vba-code.

Can you please help me out?

Regards,
Peter