Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Capturing a checkbox caption into a worksheet.
Hi
This is what I am trying to do. I have about 170 checkboxes on worksheet. What I want to happen is when I select certain checkboxes then click a command button, it will pull the caption off eac selected checkbox and will populate it into another worksheet in colum A starting on line 3 in a list format. Can anyone think of a way this can be done? Any help would be greatly appreciated because I am at a loss and I a reaching a deadline. thanks rot -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Capturing a checkbox caption into a worksheet.
There are 2 different types of checkboxes that you can have on a worksheet--one
is from the Forms toolbar and the other is from the Control toolbox toolbar: Option Explicit Sub testme() Dim CBX As CheckBox 'from the Forms toolbar Dim oRow As Long oRow = 2 For Each CBX In Worksheets("sheet1").CheckBoxes If CBX.Value = xlOn Then oRow = oRow + 1 Worksheets("sheet2").Cells(oRow, "A").Value _ = CBX.Caption End If Next CBX End Sub Sub testme2() Dim OLEObj As OLEObject Dim oRow As Long oRow = 2 For Each OLEObj In Worksheets("Sheet1").OLEObjects If TypeOf OLEObj.Object Is msforms.CheckBox Then If OLEObj.Object.Value = True Then oRow = oRow + 1 Worksheets("sheet2").Cells(oRow, "A").Value _ = OLEObj.Object.Caption End If End If Next OLEObj End Sub "rott <" wrote: Hi This is what I am trying to do. I have about 170 checkboxes on a worksheet. What I want to happen is when I select certain checkboxes, then click a command button, it will pull the caption off each selected checkbox and will populate it into another worksheet in column A starting on line 3 in a list format. Can anyone think of a way this can be done? Any help would be greatly appreciated because I am at a loss and I am reaching a deadline. thanks rott --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert a CheckBox in a Excel 2007 worksheet?? | Excel Worksheet Functions | |||
checkbox and worksheet | Excel Discussion (Misc queries) | |||
CheckBox value to worksheet | Excel Programming | |||
Capturing Checkbox Events | Excel Programming | |||
accessing CheckBox on Worksheet | Excel Programming |