activate Method on activex textbox in Group on Excel Sheet

[irfankhan640]

I have an Excel Sheet with 10 Textboxes and I group them Together. The Activate method work fine when I Ungroup them But When I group them the Activate method Generate an error. What I want to do is On keyPress or KeyUp or keyDown event when I enter data in Textbox1 and when I press enter key or tab key the Focus Get to Textbox2. See the Attached file.

I have tried both ActiveSheet.TextBox2.Activate and ActiveSheet.OLEObjects("TextBox2").Activate Both Generates error. When I ungroup them Then the First Statements work Fine.
Thanks in Advance

 

[Andrew Poulsom]

If it doesn't work when the TextBoxes are grouped you will need to ungroup them.

 

[irfankhan640]

Is there any way to Activate another textbox by KeyPress Event in Group?

 

[Andrew Poulsom]

I tried like you did without success. Why do you need the TextBoxes to be grouped?

 

[irfankhan640]

I have an excel Application First I put there 2 Frame Controls each Frame had 60 Textboxes I tried to Activate events on TextBoxes within the Frame But I could Not succeed. After that I think to put Textboxes on the Sheet and Group them Together So it will be easy for us to Drag TextBoxes from One Place to another on the Sheet, but I fail again by activate the TextBox in Group.