If then and 2 cell values

[Guest]

I am trying to run the following statement... which works fine for whatever
my N6 value is. however, I would like it to run the same way if either cell
N6 or O6 has the conditional properties in the statment. Do I need to run
some sort of loop? Can I put in an "OR" so that ... If Len(Range("n6") OR
("o6").Value) = 3 Then......
I think I need to run a loop that will run, but I have only worked with VBA
for a couple of weeks so I am not exactly sure.

If Len(Range("n6").Value) = 3 Then
SendKeys "{TAB}"
SendKeys "{TAB}"
SendKeys "{TAB}"
SendKeys "{TAB}"
SendKeys "{TAB}"
ElseIf (Range("n6").Value) = "fedl" Then
SendKeys "{TAB}"
SendKeys "{TAB}"
SendKeys "{TAB}"
Else:
SendKeys "{TAB}"
SendKeys "{TAB}"
End If

Thanks for the help!!!

 

[Tom Ogilvy]

If Len(Range("n6").Value) = 3 or _
len(Range("O6").Value) = 3 Then
SendKeys "{TAB}"
SendKeys "{TAB}"
SendKeys "{TAB}"
SendKeys "{TAB}"
SendKeys "{TAB}"
ElseIf Range("n6").Value = "fedl" _
or Range("O6").Value = "fedl" Then
SendKeys "{TAB}"
SendKeys "{TAB}"
SendKeys "{TAB}"
Else:
SendKeys "{TAB}"
SendKeys "{TAB}"
End If

 

[Guest]

Tom, thanks your statment works, but I have a new issue due to the nature of
the way I described the issue. If between N6 and O6 ...only one of the cells
meets the conditions of the If Then statement, then the statement works. If
both N6 and O6 have values that meet one of the conditions then the statement
will not work. IE - If N6 len = 3 and O6 = "fedl""... am I making myself
clear? Will I need to run another If then statement?

 

[Guest]

Tom,

I think this is an application issue, where the number of {TABS} I send
changes if both conditions are true...

 

[Tom Ogilvy]

Then you would have to spell out what to do in each instance.

 

[Guest]

Yep, thanks for the help

Then you would have to spell out what to do in each instance.