Tab Order Dependent On Prior Response

[UnreadSix]

Hello,

I have found a code to do partially what I need it to do however I need to modify it so that it calls a different array of cells if a certain option has been selected. The tab orders are as follows. Thanks in advance. I will post the code below





"G35", "G37", "G39", "G41", "G43", "G45" This is true for all cases

next if cell "G41" = "Retail" Then

"G43", "G45", "G47", "K35", "K37", "K39", "K41", "K43 "K45", "K47", "G50"

else

"G43", "G45", "G50"

If "G50" = "Tank & Toolbar" Then

"G56","G58","G60","G67","G69","G71","G73","G75","G77","G82","G84","G86","G88","K56","K58"

If "K58" = "Tow Behind" Then

"K67","K69","K71","K73","K75","K77","K82","K84","K86","K88"

Else

"K60","K67","K69","K71","K73","K75","K77","K82","K84","K86","K88"


Elseif "G50" = "Toolbar Only" Then

"G56","G58","G60","G67","G69","G71","G73","G75","G77","G82","G84","G86","G88"

Elseif "G50" = "Tank Only" Then

If "G58" = "Tow Behind"

"G56","G58","G67","G69","G71","G73","G75","G77","G82","G84","G86","G88"

Else

"G56","G58","G60","G67","G69","G71","G73","G75","G77","G82","G84","G86","G88",