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