"Otto Moehrbach" wrote in message
...
See if this fits with what you have in mind. Imagine that you have
several cells, left to right, on some otherwise blank sheet. There would
be headers above these cells to identify each cell, like Name, Grade,
etc,.
The Name cell would be a Data Validation cell. When you click on that
cell, a drop-down arrow appears to the right of that cell. Click on the
down arrow and you see all the names listed. Click on the name you want.
Then enter the grade and other things in the other cells. Finally, there
would be a button above/below/next to these cells. Click on that button
and all the data would be placed where you want it. No scrolling. No
hunting for the right cell. No changing of sheets. Post back if you
think this would be of help to you. HTH Otto


Hey, Otto,

This is almost there. But not completely yet...

- "Click on the down arrow and you see all the names listed. Click on the
name you want. "

This will be horribly time consuming thinking about I have 200+ students to
enter grades...

I cannot go by searching the names by my eye;

I have to use some kind of auto-completion feature -- I type the first a few
letters of the students name and the program locate the student for me.

- "No scrolling. No hunting for the right cell. "

Exactly, who wants to play with the cells? That's a terrible UI interface.

All I want is to enter a bunch of scores associated with the name, and then
once I am done, I specify which column of Excel should all these scores go
into. That's all. It can be Test1, Test2, Test3, etc.

----------------------------------------

The best GUI I think it should be:

1. I specify a column in Excel from which the program obtain the names;

2. The program keeps popping up a window, asking me to type the name, by
auto-completion, I just need to type a few letters, and it should be fast
for me to locate the person from out of the 200+ students I am having;

3. Then I enter a score to be associated with that student;

4. Repeat 2 and 3;

5. After the above is done, I specify a column in Excel to which the scores
are stored...

-------------------------------------

Do you know a way of doing this? Currently searching and entering scores
kills me...

Thanks a lot!