I have read a couple various things on this, but cant quite wrap my head around it.
I am trying to make a module for check boxes. When a check box is checked, it will determine the range to be used. Essentially if a column has formulas that use the range of the A column, I want a "B" check box that when it is selected, sets the range to the B column. This is for a "report" I have built within Excel to show various stages of a project. So if we want to see the financials of stage 1 of the project, we would select that check box but if we wanted say stage 4 we would select that check box. All of the data is within another sheet in the same workbook.
How complicated would this be to do? Or am I over thinking it and it is simple?
I am trying to make a module for check boxes. When a check box is checked, it will determine the range to be used. Essentially if a column has formulas that use the range of the A column, I want a "B" check box that when it is selected, sets the range to the B column. This is for a "report" I have built within Excel to show various stages of a project. So if we want to see the financials of stage 1 of the project, we would select that check box but if we wanted say stage 4 we would select that check box. All of the data is within another sheet in the same workbook.
How complicated would this be to do? Or am I over thinking it and it is simple?