Should be simple but I cannot figure it out... is there a way to use the
enter key to navigate records? Basically I have a user form and am loading
variables in it's fields based upon the values in a spreadsheet.

I want it so that each time the enter key is pressed the cursir drops a row
and the user form is then repopulated with the data.

I know how to use accelerator keys to speed up entry but i cannot figure
out how to accompplish this simple task. Any help much appreciated, thansk
and regards, mark