J
Jahunga
Data validation would not work as the result I require from th
spreadsheet is dependant upon which option is chosen. As a result o
this I need to attch code to clear all combo box's (cannot attach cod
to data validation)
E.g. If combo box one is selected then the spreadsheet shows th
results from that, then if combox two is selected i need all othe
combos to be blank so that the user is aware the result is only fro
the selected combo
spreadsheet is dependant upon which option is chosen. As a result o
this I need to attch code to clear all combo box's (cannot attach cod
to data validation)
E.g. If combo box one is selected then the spreadsheet shows th
results from that, then if combox two is selected i need all othe
combos to be blank so that the user is aware the result is only fro
the selected combo