Ethan
05-02-2012, 12:13 PM
Hello all,
I try the following but it does not work. [error = "object required"]
Can anyone tell me why?
If CheckBox1 = True And TextBox2.Value < texbox7.Value Then GoTo Option1
If CheckBox1 = True And TextBox2.Value > TextBox7.Value And TextBox2.Value < TextBox7.Value + TextBox8.Value Then GoTo Option2
If CheckBox1 = True And TextBox2.Value > TextBox7.Value + mytot3 + mytot2 Then GoTo Option3
Option1:
MsgBox ("Verlof")
Option2:
MsgBox ("Verlof & BW")
Option3:
MsgBox ("Verlof & BW & TVT")
I try the following but it does not work. [error = "object required"]
Can anyone tell me why?
If CheckBox1 = True And TextBox2.Value < texbox7.Value Then GoTo Option1
If CheckBox1 = True And TextBox2.Value > TextBox7.Value And TextBox2.Value < TextBox7.Value + TextBox8.Value Then GoTo Option2
If CheckBox1 = True And TextBox2.Value > TextBox7.Value + mytot3 + mytot2 Then GoTo Option3
Option1:
MsgBox ("Verlof")
Option2:
MsgBox ("Verlof & BW")
Option3:
MsgBox ("Verlof & BW & TVT")