get an error if i press calculate-1 button without entries in the 4 Labels in Red

[bakerman]

Put following code at start of commandbutton-code

    For Each it In Array(7, 8, 9, 17)
        If Me("Textbox" & it) = vbNullString Then MsgBox "Missing value": Exit Sub
    Next

Coloring textboxtext will only work if enabled. They are now greyed out because of disabling them.