Tab to specific cells

[Guest]

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.

 

[Gord Dibben]

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

 

[Zack Barresse]

This may help ..

http://www.vbaexpress.com/kb/getarticle.php?kb_id=209

 

[Guest]

thanks for the help. it was easy to understand. i appreciate the response.