Combo box
 

Ive tried the below - howver doesnt seem to call CL, always calls "Value"

Thanks

Private Sub ComboBox1_Change()

If Worksheets("Sheet1").Range("AA3").Value = "C" Then
Call CL
Else
Call Value
End If
End Sub

Combo box
 

Has been answered - thanks

"teresa" wrote:

Ive tried the below - howver doesnt seem to call CL, always calls "Value"

Thanks

Private Sub ComboBox1_Change()

If Worksheets("Sheet1").Range("AA3").Value = "C" Then
Call CL
Else
Call Value
End If
End Sub

Combo box
 

Teresa,

Not sure of what you solution is but in you original post you have
apparently used the word "Value" as the name of a macro. This is NOT a good
idea, as Value is a reserved word with a specific meaning in vba

"teresa" wrote:

Has been answered - thanks

"teresa" wrote:

Ive tried the below - howver doesnt seem to call CL, always calls "Value"

Thanks

Private Sub ComboBox1_Change()

If Worksheets("Sheet1").Range("AA3").Value = "C" Then
Call CL
Else
Call Value
End If
End Sub