xlon

Hi I want to insert a formula in the cell left to a check box, if the CheckBoxes.Value = xlOn : Sub test() For i = 53 To 102 If ActiveSheet.CheckBoxes(i).Value = xlOn Then ActiveSheet.CheckBoxes(i).TopLeftCell.Offset(1, 0).Formula = ("=2+2") End If...

Hello guys, I've written some VBA to control some checkboxes but it's causing an issue that I can't quite get my head around fixing and was wondering if anyone here had any ideas. So basically I have a stacked bar chart. I have a list of options (about 20) that can be individually clicked to...

Hey folks, I have been trying to create a macro that will either create a single workbook, or loop through a list a create a workbook for each name in the list. The range is called "Physical Site" and is really a European country in this case. It will create a single workbook. The issue occurs...

Hey folks, I have been trying to create a macro that will either create a single workbook, or loop through a list a create a workbook for each name in the list. The range is called "Physical Site" and is really a European country in this case. It will create a single workbook. The issue...