radio buttons/counting

Tracy Woolery · Feb 11th 2003

I built a phone estimator and want to track the amount of times I give estimates during a month.

I want to use a radio button to count the number of times used.
Then at the end of the month give a report of how many times an estimate was given and how many were sold.

Dave Hawley · Feb 11th 2003

Hi Tracy

Welcome to the OzGrid Excel Forum.

Depending on just how many Option Buttons you think you will need I would opt for another method that uses the Worksheet Selection Event, e.g

Have a Cell Ticked Upon Selection

This code must be placed in the Private Module of the Worksheet. To get there right click on the sheet name tab and select "View Code".

This code is an alternative to Checkboxes and can save a lot of space and is much easier to count the ticks! Just use the COUNTIF Function. This code works on only range A1:A10, but can be modified to suit. It could also be used in the Before Double Click event.

Code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 If Target.Cells.Count &gt; 1 Then Exit Sub
    If Not Intersect(Target, Range("A1:A10")) Is Nothing Then
        Target.Font.Name = "Marlett"
        If Target = vbNullString Then
           Target = "a"
        Else
           Target = vbNullString
        End If
    End If
End Sub

Display More

radio buttons/counting

Participate now!

Share