If Function question
Closed
Captain M
-
Nov 4, 2009 at 09:19 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 5, 2009 at 06:24 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 5, 2009 at 06:24 AM
Related:
- If Function question
- Agp function - Guide
- Yahoo mail forgot password and security question - Guide
- Network card function - Guide
- Find function on mac - Guide
- Function of insert key - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 5, 2009 at 06:24 AM
Nov 5, 2009 at 06:24 AM
did not understand. I am rephrasing your question
In column A wherever XXx is entered then in the column B of the same row will be yyy and in column C of same row will be zzz.
if this understanding is correct then follow these instruction
right click the sheet tab and click view code
in the resuting window copy paste this EVENT CODE"
Now inthe sheet in column type some entry other than xxx see what happens
again in some other cell in column A enter xxx then see what happens.
if this is ok confirm
In column A wherever XXx is entered then in the column B of the same row will be yyy and in column C of same row will be zzz.
if this understanding is correct then follow these instruction
right click the sheet tab and click view code
in the resuting window copy paste this EVENT CODE"
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column <> 1 Then Exit Sub If Target = "xxx" Then Cells(Target.Row, "b") = "yyy" Cells(Target.Row, "c") = "zzz" End If End Sub
Now inthe sheet in column type some entry other than xxx see what happens
again in some other cell in column A enter xxx then see what happens.
if this is ok confirm
