DeanP
11-25-2018, 07:57 AM
I have a macro that is run when a command button is clicked in another sheet (INPUT).
I want a checkmark to be placed in cell G7 of the INPUTS worksheet, and that worksheet to become the active sheet once the macro on the datasheet has run.
I don't want to have to do anything in the target sheet (ie double clicking).
I have researched but cannot find anything referring to placing a checkmark in a single cell.
So far I have:
Sheets("INPUTS").Select
Range("G7").Select
Any help would be appreciated.
I want a checkmark to be placed in cell G7 of the INPUTS worksheet, and that worksheet to become the active sheet once the macro on the datasheet has run.
I don't want to have to do anything in the target sheet (ie double clicking).
I have researched but cannot find anything referring to placing a checkmark in a single cell.
So far I have:
Sheets("INPUTS").Select
Range("G7").Select
Any help would be appreciated.