Solved: Auto Populate Cell With Text

[hobbiton73]

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.

[vba]If Target.Column = 9 Then
If Target.Value = "E" Then
Target.Offset(, 1).Value = "Enter the EN Number"
End If
End If[/vba]
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

[Simon Lloyd]

this may help you understand a bit further[VBA]

If Target.Column = 9 Then
If Target.Value = "E" AND Target.Offset(0,1).Value >0 Then
Target.Offset(, 1).Value = "Enter the description from column 10"
End If
End If

[/VBA]

[hobbiton73]

Hi @Simon Lloyd, thank you for taking the time to read my post and send the solution.

It's exactly what I was after!

Many thanks and kind regards