To Create A Macro Based On Events

I am trying to create a macro based on events. The event should be triggered as soon as the user leaves the cell by clicking on a different cell or by using the arrows on the keyboard. So if the user type SONY in cell A1, A2-A10 will be populated right on the spot automatically based on the word Sony, for example A2 will have electronic populated automatically, A3 will have Japan...and so on

If the user enter GMC instead in cell A1, A2-A10 will be populated right on the spot automatically based on the word GMC. A2 will have Automaker populated automatically, A3 will have USA, ...and so on.

After I created a small VB sample it looks like I need to press the execute button every time to run the program in VB instead of triggering an event automatically.

Here is a small sample I am using to test:

Sub test()

If Range("a1").Value = 10 Then

Range("c1").Value = "Yes"
Else
Range("c1").Value = "No"
End If

End Sub