Replies

Thanks all,
I like Steves solution since the workbook will be a template type of application.
This way I won’t have to have the user see any blank sheets before or after the sheets they add.
Scott

Steve,
Thanks
The problem with your solution is that I won’t know what the sheet names are going to be.
As I understand 3D references need the beginning and ending sheet names.
Scott

Thanks,
I will play around with the controls.

Scott

Hans,
I created them from the Forms tooolbar.

Hans,
It could be looked at either way. The way this application will be used, the boxes below should be cleared.
Always learning,
Scott

Hans,
Thanks for the help. I also modified the second macro so if the checkbox is unchecked(checked by mistake),
the cells below also uncheck.

Sub CheckBoxClick()
    Dim oCell As Range
    Dim r As Long
    With ActiveSheet.Shapes(Application.Caller).ControlFormat
        If .Value = 1 Then
            Set oCell = Range(.LinkedCell)
            For r = oCell.Row + 8 To 91 Step 8
                Cells(r, oCell.Column) = 1
            Next r
        ElseIf .Value < 1 Then
            Set oCell = Range(.LinkedCell)
            For r = oCell.Row + 8 To 91 Step 8
                Cells(r, oCell.Column) = 0
            Next r
        End If
    End With
End Sub

Thanks again.

Hans,
As always, Thank you.
I see I was using the listbox properties wrong.

I’ve run into another problem with the listbox. It seems that after resetting the listboxes, you have to click twice on any other control to activate it.
My guess is the first click gets you out of the first listbox and the second click actually activates whatever you click on.
I included a stripped down version with the offending listboxes and a couple of other items to click on.
Can someone see why its getting stuck?
Thanks,
Scott

Sorry, I asked for help too soon.
I found a bit of code in the previous listbox that still had control.
Scott

Hans,
Thanks, I never thought to use a binary type approach.
Works for me.

Hans,
Thanks. I will look over the way you did this.
Thanks.
Scott

Gary,
Thanks for the additional info. Each question has a target value which I didn’t include.
If the calls per tech didn’t reach the target value say 3 then the box would be checked no.
The questions aren’t about an individual, they are about the site location as a whole.
Scott

Hans,
I think I get the idea. I created the tables but I can’t figure out how to relate them so I can enter data on a form
showing the questions for different visits. I must be brain-dead today because I can’t see it.
I attached what I have so far.

Thanks for your help
Scott

Hans,
Thanks. That helped me finish the sheet.
Works great.
Scott

Hans,
Yes I do. Unless you can think of another way to show that a value has been changed.
The working sheet will have around 150 rows.
I want an easy way to let the sender of the sheet know when a user makes a change and sends it back.
There may only be a couple of changes on the sheet and it would be hard to compare the changed sheet with the original sent.
If I change an option button and try to close, I’m asked if I want to save the changes so something is seeing that I changed data.
Is there a way to use the Calculate event?

Scott

Scott.