ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tab keeps cycling through the same row (https://www.excelbanter.com/excel-discussion-misc-queries/198776-tab-keeps-cycling-through-same-row.html)

Mike

Tab keeps cycling through the same row
 
I have created a form in Excel 2003. When tabing throug the form instead of
dropping down to the next cells in the next row down, it goes back to the
beginning and keeps cycling. IE Tabing A1 to A6 then should go to B1 instead
goes back to A1. Any suggestions would be great. Thanks Mike

Bob Phillips

Tab keeps cycling through the same row
 
Some code would help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mike" wrote in message
...
I have created a form in Excel 2003. When tabing throug the form instead of
dropping down to the next cells in the next row down, it goes back to the
beginning and keeps cycling. IE Tabing A1 to A6 then should go to B1
instead
goes back to A1. Any suggestions would be great. Thanks Mike




Gord Dibben

Tab keeps cycling through the same row
 
How have you set the Tab Order? Named range? Unlocked cells on a protected
sheet?

Normally Tab goes across a row, A1, B1, C1 not down a column from A1, A2, A3

Or do you have rows and columns mixed up in your mind?


Gord Dibben MS Excel MVP

On Wed, 13 Aug 2008 15:18:01 -0700, Mike
wrote:

I have created a form in Excel 2003. When tabing throug the form instead of
dropping down to the next cells in the next row down, it goes back to the
beginning and keeps cycling. IE Tabing A1 to A6 then should go to B1 instead
goes back to A1. Any suggestions would be great. Thanks Mike




All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com