Hi, i’ve built a summary worksheet that now has more cells with formulas than I had originally planned.
I have an combo box (form control) which a user chooses a value from a list of cities, The selection is linked to a helper sheet which works out the stores within the selected city, which are then picked up with lookup formulas on the summary sheet. There are then a bunch more formulas that show this and that metric for all the stores shown.
Is is possible to link a macro to the combo box as I need to calculate 2 sheets out of 8 in the workbook once the selection in the combo box changes.
Thanks
I have an combo box (form control) which a user chooses a value from a list of cities, The selection is linked to a helper sheet which works out the stores within the selected city, which are then picked up with lookup formulas on the summary sheet. There are then a bunch more formulas that show this and that metric for all the stores shown.
Is is possible to link a macro to the combo box as I need to calculate 2 sheets out of 8 in the workbook once the selection in the combo box changes.
Thanks
