Worksheet Change Help

[andrewb90]

Hello,

I have this:

If Len(Target.Value) > 3 And Len(Target.Value) < 31 Then

, I am trying to see if I can go from requiring an entry length to requiring a certain entry. such as "Blue Moon" basically once that phrase is entered, then my code will execute.

thanks,

Andrew

 

[Teeroy]

You just need;

If Target.Value="Blue Moon" Then

but this would run if you typed it anywhere on the sheet. Personally I would restrict it to a location or range and test the value e.g.

If Target.Address = "$A$1" and Target.Value= "Blue Moon" Then

or

If Target.Column= 1 and Target.Value= "Blue Moon" Then 'for column A

 

[andrewb90]

Awesome! Yes, I would want it typed only in a specific range like A1. Thank You!!