Problem
on a combo box you click on an item to run a macro...here is the coding:-
Case "option1"
Sheets("TS Buttons").Select
so when you click on option1 you are taken to 'TS buttons' sheet. The 'Option1' is picked up from a List Fill Range...however this is an ever changing range...so how do I code if say option1 is replaced by Option2...but I still want it to go to the same sheet....the coding above is for option1 alone...
on a combo box you click on an item to run a macro...here is the coding:-
Case "option1"
Sheets("TS Buttons").Select
so when you click on option1 you are taken to 'TS buttons' sheet. The 'Option1' is picked up from a List Fill Range...however this is an ever changing range...so how do I code if say option1 is replaced by Option2...but I still want it to go to the same sheet....the coding above is for option1 alone...
