Hi guys,
I have a checkbox within a cell and how my macro works is that I select the cell containing the box of the checkbox. When I click the checkbox the macro executes. Question is how would I do this entirely in VBA? The checkbox is always in Column A of the activerow.
I am working on a Capital Call to General Ledger macro and need it so in the GL tab after all information is pulled from the capital call tab, the first column of the active row becomes selected and then the checkbox is ticked. There are no predefined names for these checkboxes as they auto create after each time I click the boxes.
The way I am doing right now and it seems to have a different effect is that I am selecting the correct cell however using the call command to run the macro. This runs the macro but doesn't show the tick mark and work the way had I just pulled info and manually click the box. Its an odd behavior but I am sure my scripting isn't all logical lol.
I have a checkbox within a cell and how my macro works is that I select the cell containing the box of the checkbox. When I click the checkbox the macro executes. Question is how would I do this entirely in VBA? The checkbox is always in Column A of the activerow.
I am working on a Capital Call to General Ledger macro and need it so in the GL tab after all information is pulled from the capital call tab, the first column of the active row becomes selected and then the checkbox is ticked. There are no predefined names for these checkboxes as they auto create after each time I click the boxes.
The way I am doing right now and it seems to have a different effect is that I am selecting the correct cell however using the call command to run the macro. This runs the macro but doesn't show the tick mark and work the way had I just pulled info and manually click the box. Its an odd behavior but I am sure my scripting isn't all logical lol.