How to put a column of ck boxes in MS Excel 2010

hello friends

I would like to know how to insert a column of ck boxes ( radio buttons ).   I am making a list, with Tasks as rows.  I would like to have a column where someone can check off that the task was completed.

how is this accomplished?


any help appreciated
intelogentAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ramesh VCommented:
Hi,
I think its check box you want to have, because it is radio button, if you select it by mistake, you can't make it un select.
Coming to Check box, are you making any validations or creating reports based in Selected or not selected.
Because we have to write code for each check box (Change event or after update).
Is your list is limited or it'll change frequently. Say suppose if you have 10 rows, we can add 10 check boxes and can write events for them. What if the list changes next time to 50?
I don't think its a good option to have check boxes if the list changes frequently, I can be wrong though.
But let's comments from other experts also.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
intelogentAuthor Commented:
The list will not change, although we may add additional  rows and ck boxes is best.

so are you saying that we must write code in order to get a ck box ?
Martin LissOlder than dirtCommented:
What Ramesh is trying to point out is that ck (check?) boxes and radio buttons are two different things. Checkboxes are the little square boxes that are normally used when you need to be able to select several of them, while radio buttons are little and round and are usually used when you want to select 1 of several choices, so I think you mean checkboxes.
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

Martin LissOlder than dirtCommented:
This macro will put the checkboxes in column F.

Sub CreateCheckboxes()
Dim intQuestions As Integer
Dim intRow As Integer
Dim oleObj As OLEObject

' Uncomment these lines to erase what you did and do it again
For Each oleObj In ActiveSheet.OLEObjects
    oleObj.Delete
Next
intQuestions = InputBox("How many sets of Yes/No option buttons do you want to add?", , 1)

For intRow = 1 To intQuestions
    With ActiveSheet.OLEObjects.Add(ClassType:="Forms.Checkbox.1", _
        Left:=Cells(intRow, 6).Left, _
        Top:=Cells(intRow, 6).Top, _
        Width:=Cells(intRow, 6).Width, _
        Height:=Cells(intRow, 6).Height)
        .Object.Caption = "Done?"
        .Object.GroupName = "Q" & intRow
    End With
Next

Open in new window

Ramesh VCommented:
Hi Martin,
The code you gave is working awesome.
I have a question (asked the same question with author):
What if we want to filter what are the tasks completed (say checked) or If we want to pull a report based on check box status.
Martin LissOlder than dirtCommented:
Sub QueryCheckbxes()
Dim oleObj As OLEObject
Dim intCount As Integer
For Each oleObj In ActiveSheet.OLEObjects
    If oleObj.progID = "Forms.CheckBox.1" Then
        If oleObj.Object = True Then
            intCount = intCount + 1
        End If
    End If
Next

MsgBox intCount & " checkboxes selected"
End Sub

Open in new window

Martin LissOlder than dirtCommented:
I've requested that this question be closed as follows:

Accepted answer: 500 points for Martin Liss's comment #a40795145

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.