Have you considered the built-in Data Form, found on, well,
the Data menu? Enter key moves you down a row, tab moves to next column.
Requires column labels on the worksheet.
J-Walk Enhanced Data Form (free) from...
Portland, Oregon USA
I just got up so apologies for the delay replying (I'm in Singapore).
Basically i didn't explain my goal properly and so it has been
misunderstood... I am not actually talking about navigating between controls
on the userform, I am talking about moving from one record to another.
Basically I have a arrow control which when clicked will move the row in the
worksheet down one and then refresh the userform which displays data in the
I want to dispense with the need to use a mouse to click the arrow and make
it so when you press enter it moves to the next record. Using an accelerator
key is one way to go but then instead of pressing enter the user has to do
alt - x (if x is the accelerator key assigned) to go to the njext record,
which isn't so elegant.
Sorry for the failure to communicate, any ideas?
Thanks and regards. , Mark