You can set the TabIndex number on each box so when you press the tab key you
can go from box to box.

"Mark Stephens" wrote:

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