lcCheckboxName = "Check Box 3"FOR i=1TO oSheet.CheckBoxes.Count *? i, oSheet.CheckBoxes(i).Name && Uncomment to see checkbox namesIF oSheet.CheckBoxes(i).Name = lcCheckboxName
oSheet.CheckBoxes(i).Value = 1&& CheckENDIFENDFOR
> >I created a macro in Excel to check a checkbox on the worksheet: > >oleApp.Run "MyFile.XLS!CheckBox3_Click" > >This would work great if I could just plug that in after the condition in my code, except the way it's phrased doesn't play well with VFP. Any suggestions? >