VBA Excel IF

[Isbenji]

Hello,

I am building my first VBA Macro Excel (button) and I need help with it as I am unfortunately unsuccessful. Basically in one column, I have name of the countries and I would like in the second column to have if it is a EU Country or Non-EU Country. I tried to test it only with one country (Germany) but I am still unsuccessful and it gives me the following error message

Dim customernationality As Integer, result As String
customernationality = Columns("AC").Value

If customernationality = Germany Then result = "EU Country"

Columns("AD").Value = result

I guess the code is wrong, if I may have some help with it

Thanks in advance
Benjamin

 

[Isbenji]

Thank you so much ?

 

[Joe4]

You are welcome.