user form tab index and sort code for sheet 1

Hi there just a couple of questions.

On the attached spreadsheet I am looking for code to change the tab index on userform1. Basically if optionbutton1 = true then I would like to tab through CB3 then CB4 then TB3 then commandbutton 1 not optionbutton 2, 3, 4 and then command buttton 1.

Likewise if option button 2 is selected i would like to tab through CB3, CB4, TB3, CB5,CB6, TB4 then commandbutton1 not CB3, CB4, TB3, CB5,CB6, TB4, OB3, OB4 Command button1.

Think you get the idea from this.

Also with this userform is there anyway to adjust the size of the userform depending on which option button is selected? So that it wont leave a large blank area if only 1 is selected?

Finally is it possible to add some code to commandbutton1 so that after an entry has been made to sheet 1 (products) it will put all the products in sheet 1 in alphabetical order?

Thanks in advance