| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
WOW! Marvelous, Fantastic, PERFECT,,,,,,,,Thanks
"Dave Peterson" wrote: How about something like this that will assign the linked cell to Column A of the same row that holds the checkbox (from the Control toolbox toolbar): Option Explicit Sub testme() Dim OLEObj As OLEObject Dim wks As Worksheet Set wks = Worksheets("sheet1") For Each OLEObj In wks.OLEObjects If TypeOf OLEObj.Object Is MSForms.CheckBox Then OLEObj.LinkedCell _ = wks.Cells(OLEObj.TopLeftCell.Row, "A") _ .Address(external:=True) End If Next OLEObj End Sub If you're new to macros, you may want to read David's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Change that "A" to whatever column you really want. Tony wrote: Thanks Dave, This worked exactly like you said it would. I have 5,000 rows, do I have to do the LINKCELL for every row. "Dave Peterson" wrote: You can set up a LinkedCell for each checkbox. (It's under properties when you rightclick on the checkbox (while in design mode).) Then you can put those in a column (hidden) in the same row as the checkbox. then =countif(e:e,true) (use the correct column, though) Tony wrote: I have created a column that has check Boxes using the Control Toolbar. How do I count the total number of checkc boxs in a column, that have check marks in them. I do not know VBA, only know how to create and paste a function was already set up for me. Thanks in advance, Tony -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protection of check boxes in excel 2002 | Excel Discussion (Misc queries) | |||
| use check boxes in excell | Excel Worksheet Functions | |||
| How to align check boxes on an Excel sheet? | Excel Worksheet Functions | |||
| Adding Check Boxes | Excel Discussion (Misc queries) | |||
| Filters and Check Boxes | Excel Worksheet Functions | |||
Threaded Mode
