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