ComboBox1_Change - Code

[VBABEGINER]

Hi Guys,
Dont understand what wrong here..

Private Sub ComboBox1_Change()
If ComboBox1.Value = "Projects" Or ComboBox1.Value = "Process Training" Or ComboBox1.Value = "Tech Meeting" _
Or ComboBox1.Value = "Allocation" Or ComboBox1.Value = "Stake holder reviews" Or ComboBox1.Value = "Reporting" Or ComboBox1.Value Then

 

[BiocideJ]

Neither do we. What problem are you having?
I am assuming there is more to this VBA because you have the IF portion, but THEN ...what?

 

[VBABEGINER]

Hi...Thanks for reply.
Off course, i have code after "Then"..but error stopped at If line...hence given that much only...
Here is the code-

Private Sub ComboBox1_Change()
If ComboBox1.Value = "Projects" Or ComboBox1.Value = "Process Training" Or ComboBox1.Value = "Tech Meeting" _
Or ComboBox1.Value = "Allocation" Or ComboBox1.Value = "Stake holder reviews" Or ComboBox1.Value = "Reporting" Or ComboBox1.Value Then


TxtCaseID.Visible = False
TxtEETime.Visible = False
cmbClientName.Visible = False
cmbTaskName.Visible = False
cmbTaskStatus.Visible = False


LblCaseID.Visible = False
LblEETime.Visible = False
LblClientName.Visible = False
LblTaskName.Visible = False
LblTaskStatus.Visible = False
End If
End Sub

 

[Norie]

What's the error message?

 

[VBABEGINER]

Type Mismatch

What's the error message?

 

[gallen]

You don't have a value on the last or...

If ComboBox1.Value = "Projects" Or ComboBox1.Value = "Process Training" Or ComboBox1.Value = "Tech Meeting" _
Or ComboBox1.Value = "Allocation" Or ComboBox1.Value = "Stake holder reviews" Or ComboBox1.Value = "Reporting" Or [COLOR=#ff0000][B]ComboBox1.Value[/B][/COLOR] Then

 

[VBABEGINER]

Yes, got it..Thanks for your reply too..