Consecutive Sendkeys commands won't work

Hi Kaper. Thanks very much for the reply and trying to help.

I don't know if you solution will work. The text that I am trying to select from the pick list is any one of eight variables, which tells one formula what chord to select. The result of that formula, is used as a variable in another program. As I said, this is all a part of a fairly complicated excel program, and not just "i need this number". Maybe what you are suggesting can work, but let me tell you what is happening.

A quick example is a cmajor scale. If you were playing the single notes, they are C,D,E,F,G,A,B,C.
D for example is the D second degree of the scale, E is the third degree, etc. But a scale can also be played harmonized, utilizing the chords that fall into that scale. (based on scale type, (Major, Minor, etc..) If your a musician, you might know this stuff.. it's music theory, if you do, please excuse my restating it.

So, a Cmajor scale, chorded (or "harmonized" , is
C Major D Minor E Minor F Major G Major A Minor B Diminished C Major.

My program will display those chords, telling a person how and where to play them on the pedal steel. So to do that, I have to know the notes that are involved in those chords.

I have everything working fine in the program. I can pick the scale, (in this case C, and the Scale type, in this case "Major", and the "degree" I want, First through Eighth (that's the pick list) and program returns the correct chord. So If I pick "Third" from the drop down, I am returned an E Minor chord. Ok so far.

I want my macro to move from third to fourth, by pressing a button, (or first to second, second to third, whatever). While using my program, a person will have finger picks on, so typing is an issue. But he could click the "Advance Scale Degree" button, and continue his practicing/playing.

When you pick second, it feeds that variable into this formula, to find the starting note of the chord.
=VLOOKUP($B$39,onlynotesarray,HLOOKUP($D$39,SCALEDEGREES,4,FALSE),FALSE) This returns the value "E", the starting note of the third degree scale chord.
Then, there are two more formulas that look up the notes, for that scale type , and that starting note.

=IF($D$39="major_",VLOOKUP(I27,onlynotesarray,HLOOKUP("minor",allchordtypes,3,FALSE),FALSE),IF($D$39="Minor_",VLOOKUP(I27,onlynotesarray,HLOOKUP("Major_Chord",allchordtypes,3,FALSE),FALSE),IF($D$39="Harmonic_Minor",VLOOKUP(I27,onlynotesarray,HLOOKUP("AUG",allchordtypes,3,FALSE),FALSE),IF($D$39="Melodic_Minor",VLOOKUP(I$27,onlynotesarray,HLOOKUP("Aug",allchordtypes,3,FALSE),FALSE),IF($D$39="Augmented",VLOOKUP(I27,onlynotesarray,HLOOKUP("Blues_7th",allchordtypes,3,FALSE),FALSE))))))

This formula evaluates the second note I need, which happens to be the value "G".

As you can see, I have some pretty complicated stuff here.
I don't know how I can incorporate you solution into this mechanism.

??
Thanks Again.