| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to select cells in column enter data then press enter | New Users to Excel | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Enter info in one sheet, auto enter in another based on one field | New Users to Excel | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
Hybrid Mode
