VBA Help - If .Range ("CellLink") - Application defined or object defined error

[ExcelLearner_]

Hi All,

I have created a combo box and would like to execute VBA according to selection from combo box.
I have used the same VBA code previously without any error. But since I upgrade to excel 2016 I got error message as shown below. Not sure if it's due to 64 bit system? Can anyone here shed some light, please?

Sub login()
With ActiveSheet
If .Range("celllink") = 1 Then
>> Run time error 1004. Application defined or object defined error
Call VBA_1
ElseIf .Range("celllink") = 2 Then
Call VBA_2
End If
End With
End Sub

 

[JonXL]

What if you use

.Range("celllink").Value

?

 

[ExcelLearner_]

Hi JonXL,

You mean amend code to
if .range("cellLink").value = 1 ?

I amend the code to below and it works..
if .range("A1") = 1

Still don't understand why the initial coding works on previous excel version but not version 2016..