Heres my problem.

I have written 5 macro and created an excel spreadsheet with 5 tick boxes and a button. I have the tick boxes set to show "true" when one is ticked on a cell beside it and false if unticked. Now what I want is a macro that is assigned to the button so when the button is clicked on it will search the cells and find which cell displays the value "true" and then run the appropriate macro.

many thanks