Hello,
I have been looking into this for awhile. I have a very basic knowledge with excel 2003.
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 <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com
ffice:smarttags" /><st1:country-region w:st="on"><st1
lace w:st="on">Japan</st1
lace></st1:country-region>...and so on <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
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 <st1:country-region w:st="on"><st1
lace w:st="on">USA</st1
lace></st1:country-region>, ...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.
Can you please help? Here is a small sample I am using to test:
<o
></o
>
Sub test()<o
></o
>
<o
></o
>
<o
></o
>
If Range("a1").Value = 10 Then<o
></o
>
<o
></o
>
Range("c1").Value = "Yes"<o
></o
>
Else<o
></o
>
Range("c1").Value = "No"<o
></o
>
End If<o
></o
>
<o
></o
>
<o
></o
>
End Sub
I have been looking into this for awhile. I have a very basic knowledge with excel 2003.
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 <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com







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 <st1:country-region w:st="on"><st1


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.
Can you please help? Here is a small sample I am using to test:
<o


Sub test()<o


<o


<o


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


<o


Range("c1").Value = "Yes"<o


Else<o


Range("c1").Value = "No"<o


End If<o


<o


<o


End Sub