ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tab Order (https://www.excelbanter.com/excel-discussion-misc-queries/30091-tab-order.html)

jneal

Tab Order
 

I am creating a form using Excel. The users want to tab to the correct
cell. The protected cells does not work because it goes left to right.
I need to go down and then over, up and so on. Anyone have any ideas?

Thanks in advance,

Jim


--
jneal
------------------------------------------------------------------------
jneal's Profile: http://www.excelforum.com/member.php...o&userid=23176
View this thread: http://www.excelforum.com/showthread...hreadid=377957


Paul B

jneal, see if this will work for you

http://www.xldynamic.com/source/xld.xlFAQ0008.html

If not this can also be done with VBA

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"jneal" wrote in
message ...

I am creating a form using Excel. The users want to tab to the correct
cell. The protected cells does not work because it goes left to right.
I need to go down and then over, up and so on. Anyone have any ideas?

Thanks in advance,

Jim


--
jneal
------------------------------------------------------------------------
jneal's Profile:

http://www.excelforum.com/member.php...o&userid=23176
View this thread: http://www.excelforum.com/showthread...hreadid=377957





All times are GMT +1. The time now is 07:17 PM.

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