Tabbing Autoshapes in Excel 2010

[johnaldo]

Hi

I have been using Excel 2003 for a few months now and creating a form on a sheet as opposed to a Userform is preferred due to it's versatility with Autoshapes.

However, I am now working from Excel 2010 and trying to do the same thing. Everything about 2010 is better for this task other than tabbing between Autoshapes.

When selecting a shape and pressing the tab key, it will jump to the next shape exactly how I want it to. Unfortunately, when pressing tab after inserting text into an autoshape, it will indent the text and stay within the same autoshape - the only ways around this are by clicking out of the shape or pressing ESC.

I have written a macro to get around this problem by including a shortcut to press to jump between autoshapes, but I was just wondering if there was an option to disable the tab indent so I can use it for a form purpose? Excel 2003 does not have this issue. Thanks in advance

 

[johnaldo]

Is this not possible? Is there anyway for me to tell the tab key not to indent within the text but to jump to the next shape? I just want to make this as user friendly as possible rather than advising that the user will have to press Ctrl+Letter or Esc then tab.