I've made a number of Excel forms for my company. I'd like to find a way to automatically tab to the next entry field. Thanks for everyone's suggestions.

What type of forms?

Just worksheet cell selections?

There are several ways to set the TAB order on worksheet cells.

See Bob Phillips' site for methods.

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

There is another method using VBA event code.

If interested, post back for more detail and some sample code.


Gord Dibben Excel MVP

On Tue, 19 Apr 2005 21:29:56 +0100, rob8278
wrote:


I've made a number of Excel forms for my company. I'd like to find a
way to automatically tab to the next entry field. Thanks for
everyone's suggestions.

To Gord - Suggestions worked better than I hoped. I can't thank you enough.