Sorry about that really crap subject..i couldn't think of anything better.
I have a spread with two columns in it.
Column A from 3:1000 contains names. Column B from 3:1000 contains a number.
I also have two text boxes i'll call them A and B.
My aim is to type a name into text box A. When enter is pressed, text box B is selected where I will enter a number.
When Enter is pressed a second time, the name typed into A should be found in the list in Column A and then the value that was typed into B should be added the value in column B next to the name.
The text boxes should then be cleared and text box A will once again be selected.
How do I do this in code?
I have a spread with two columns in it.
Column A from 3:1000 contains names. Column B from 3:1000 contains a number.
I also have two text boxes i'll call them A and B.
My aim is to type a name into text box A. When enter is pressed, text box B is selected where I will enter a number.
When Enter is pressed a second time, the name typed into A should be found in the list in Column A and then the value that was typed into B should be added the value in column B next to the name.
The text boxes should then be cleared and text box A will once again be selected.
How do I do this in code?