hobbiton73
12-01-2012, 08:53 AM
Hi, I wonder someone may be able to help me please.
I'm using the code below to populate cells with text, giving instructions to the user on whether they need to manully enter, or select a value from a drop down menu.
If Target.Column = 9 Then
If Target.Value = "E" Then
Target.Offset(, 1).Value = "Enter the EN Number"
End If
End If
I'd now like to extend this a little further and amend the code so that it looks in two columns i.e. 'Target.Column = 9 and 10', and checks for the values 'E' in column 9 and '>0' in column 10.
The offset will then be 'Target.Offset(, 1).Value="Enter the description"' from column 10.
I just wondered whether someone could possibly look at this please and offer some guidnace on how I may go about adapting my original code to look at the values in two columns.
Many thanks and kind regards
I'm using the code below to populate cells with text, giving instructions to the user on whether they need to manully enter, or select a value from a drop down menu.
If Target.Column = 9 Then
If Target.Value = "E" Then
Target.Offset(, 1).Value = "Enter the EN Number"
End If
End If
I'd now like to extend this a little further and amend the code so that it looks in two columns i.e. 'Target.Column = 9 and 10', and checks for the values 'E' in column 9 and '>0' in column 10.
The offset will then be 'Target.Offset(, 1).Value="Enter the description"' from column 10.
I just wondered whether someone could possibly look at this please and offer some guidnace on how I may go about adapting my original code to look at the values in two columns.
Many thanks and kind regards