I am looking for help regarding a check box function.
I have a macro that fires when a checkbox is clicked on(to "check" it). The macro unhides a hidden sheet within the workbook.
I need the checkbox to not only unhide the hidden sheet, but also to copy certain cells within the Main Input sheet and copy the information to selected cells in the now unhidden worksheet.
However, I also need it to check if there is already data in that cell, and if there is copy to another designated cell, and if not go ahead and copy to the first designated cell.
With that said, can it have the functionality to move where copied if the main checkbox is "unchecked" at a later time? (as in click to "check" the box, hidden worksheet is now visible and cell A1 is copied to unhidden worksheet A1. then if another check box is checked data from cell B1 on the first sheet is moved to unhidden sheet, cell B1. But if the first box is then unchecked, the unhidden sheet's B1 information then moves to unhidden sheet's A1 cell)
Hope that makes sense, I am REALLY new to macros and the only coding I'm using has been found on this forum site.
Thank you!
I have a macro that fires when a checkbox is clicked on(to "check" it). The macro unhides a hidden sheet within the workbook.
I need the checkbox to not only unhide the hidden sheet, but also to copy certain cells within the Main Input sheet and copy the information to selected cells in the now unhidden worksheet.
However, I also need it to check if there is already data in that cell, and if there is copy to another designated cell, and if not go ahead and copy to the first designated cell.
With that said, can it have the functionality to move where copied if the main checkbox is "unchecked" at a later time? (as in click to "check" the box, hidden worksheet is now visible and cell A1 is copied to unhidden worksheet A1. then if another check box is checked data from cell B1 on the first sheet is moved to unhidden sheet, cell B1. But if the first box is then unchecked, the unhidden sheet's B1 information then moves to unhidden sheet's A1 cell)
Hope that makes sense, I am REALLY new to macros and the only coding I'm using has been found on this forum site.
Thank you!
