trying to get the RETURN key to behave like the TAB

hi all

been looked around for a bit now and can't seem to find an answer to my problem.
I have a spreadsheet which I'll be using to do some data entry

is there a way to get the RETURN key to behave like the TAB key?
in other words when they hit RETURN it would bring them to the cell directly next to it rather than the cell below (default)?

if there's a way to set that on the Vb side that would be nice since I would like that feature turned on or off depending what sheet they are on

thanks

Pabs

rock and roll! that's works well!
thanks

quick question on the subject.
within the same macro (TurOn) can I do this

Please Login or Register  to view this content.

nopaste is a local sub (simple pop up warning)


there is nothing wrong with calling multiple instances of the Application.Key correct?
it works but I'm just wondering if it won't create strange bugs..

one thing I don't get is the turn off macro.
you simply call

Please Login or Register  to view this content.

what does that do? cause it's not linking it to anything . or does it simply say return "~" to it's default?

if that's the case I would need to do something like this correct?

Please Login or Register  to view this content.

thanks again

Pabs

thanks for the help dominic...