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.

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.

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.

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.