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",

[UnreadSix]

In Module

Please Login or Register  to view this content.

in ThisWorkbook

Please Login or Register  to view this content.

In sheet1 standard code

Please Login or Register  to view this content.