Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Tab to specific cells
I'm currently using Excel 03 on Windows xp. I created forms on Excel
worksheets that have open cells where I can enter information to complete the forms. The cells where I enter the information are scattered thru out the worksheet. Insted of using the mouse or arrow keys to get to the cell I need to input the information, I want to use the Tab button to take me to each cell I need to enter information in. |
#2
|
|||
|
|||
jayjay
See Bob Phillips's site for help on this. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is another option which uses VBA and a worksheet even t code if you want. Gord Dibben Excel MVP On Fri, 6 May 2005 16:26:03 -0700, jayjay wrote: I'm currently using Excel 03 on Windows xp. I created forms on Excel worksheets that have open cells where I can enter information to complete the forms. The cells where I enter the information are scattered thru out the worksheet. Insted of using the mouse or arrow keys to get to the cell I need to input the information, I want to use the Tab button to take me to each cell I need to enter information in. |
#3
|
|||
|
|||
This may help ..
http://www.vbaexpress.com/kb/getarticle.php?kb_id=209 -- Regards, Zack Barresse, aka firefytr "jayjay" wrote in message ... I'm currently using Excel 03 on Windows xp. I created forms on Excel worksheets that have open cells where I can enter information to complete the forms. The cells where I enter the information are scattered thru out the worksheet. Insted of using the mouse or arrow keys to get to the cell I need to input the information, I want to use the Tab button to take me to each cell I need to enter information in. |
#4
|
|||
|
|||
thanks for the help. it was easy to understand. i appreciate the response.
"Gord Dibben" wrote: jayjay See Bob Phillips's site for help on this. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is another option which uses VBA and a worksheet even t code if you want. Gord Dibben Excel MVP On Fri, 6 May 2005 16:26:03 -0700, jayjay wrote: I'm currently using Excel 03 on Windows xp. I created forms on Excel worksheets that have open cells where I can enter information to complete the forms. The cells where I enter the information are scattered thru out the worksheet. Insted of using the mouse or arrow keys to get to the cell I need to input the information, I want to use the Tab button to take me to each cell I need to enter information in. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there away to have specific cells unlock based on the entry of information in another? | New Users to Excel | |||
Showing zero in specific cells | Excel Discussion (Misc queries) | |||
How do I protect specific cells from changes in Excel? | Excel Discussion (Misc queries) | |||
Locate and delete specific cells | Excel Discussion (Misc queries) | |||
Protecting specific cells in a worksheet. | Excel Worksheet Functions |