Tab/Enter
 

I've developed a spreadsheet, using macros and data validation, to be filled
out by the user as a form . Now my boss wants me to set it up so that the
user can jump from field to field by pressing tab or enter. By default it
just moves to the next cell. Is there any easier way of doing this other
than a bunch of Deactivate event code?

Tab/Enter
 

lock all cells (formt=Cells=Protection tab), Unlock the cells you want
accessible. Set the Enable Selection property to Unlocked cells only.
Protect the sheet under the Tools=Protect menu.

That would be a good start.

--
Regards,
Tom Ogilvy

"xlcharlie" wrote in message
...
I've developed a spreadsheet, using macros and data validation, to be
filled
out by the user as a form . Now my boss wants me to set it up so that the
user can jump from field to field by pressing tab or enter. By default it
just moves to the next cell. Is there any easier way of doing this other
than a bunch of Deactivate event code?

Tab/Enter
 

Perfect, that's just what I was looking for. Thanks.

"Tom Ogilvy" wrote:

lock all cells (formt=Cells=Protection tab), Unlock the cells you want
accessible. Set the Enable Selection property to Unlocked cells only.
Protect the sheet under the Tools=Protect menu.

That would be a good start.

--
Regards,
Tom Ogilvy

"xlcharlie" wrote in message
...
I've developed a spreadsheet, using macros and data validation, to be
filled
out by the user as a form . Now my boss wants me to set it up so that the
user can jump from field to field by pressing tab or enter. By default it
just moves to the next cell. Is there any easier way of doing this other
than a bunch of Deactivate event code?