I am currently re-designing an excel application due to major
complexity issues and the ability to make it better with VBA and less
confusing. I have a few validation lists per row and calculations are
made based on the stuff chosen in those lists. Lets say for example
A6 (on sheet1) contains a validation using a list defined on sheet2.
I want the list to be automatically dropped down when the user clicks
activates A6. The computer (machine) that will be using this, once it
is done, does not have a mouse.

For example:
The user clicks A6 (activates it), the list drops down (intead of
clicking the down arrow cause no mouse will be used), the user uses
the up and down arrow to choose what they want, hits enter when the
right choice is made, then hits tab to goto B6.

We are using general validation supported in Excel and no forms.

Thank You