Excel VBA Check off an activecheckbox within a cell

shyy

Well-known Member
Joined
Nov 6, 2008
Messages
1,484
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.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

shyy

Well-known Member
Joined
Nov 6, 2008
Messages
1,484
I got it the macro to work except the tick mark. Looks odd without the tickmark.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,001
Messages
5,526,203
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top