Insert Checkboxes linked to cells to indicate make graph
Posted on 2001-08-01
I have a Macro which systematically graphs grouped data on a worksheet. It basically has a start row, number of rows to go down, and number of columns. It also knows the number of groups which = the number of charts to make.
However, If I export over 255 "groups" it's too much to create seperate graphs for each. Right now, I just have a message that there are too many variables.
What I would like to do is to Insert a Column (A) called "Graph" and put a check box at each group start cell. If the checkbox is checked, the linked cell is "TRUE" and the group is graphed.
This is what I need to find out: How to add a Checkbox into a cell, link it to the cell. If I just run a macro to add a checkbox:
ActiveSheet.CheckBoxes.Add(8.25, 67.5, 24, 17.25).Select
ActiveSheet.Shapes("Check Box 2").Select
Selection.Characters.Text = ""
.Value = xlOff
.LinkedCell = "$A$5"
.Display3DShading = False
I get x,y coordinates. Is there a way to put it in a cell rather than x,y?