Jumpy, jittery option boxes

[BDD2015]

I am working on a questionnaire with radio buttons. Whenever I scroll through the sheet it gets all jumpy and jittery (for lack of better words - lol) and it's driving me crazy. I have tried the "Don't move, resize..." option but it doesn't help. Does anyone have any ideas on how to lock it down so the questionnaire doesn't look like a Mexican jumping bean whenever you scroll?

 

[My Aswer Is This]

Do you have any auto sheet event scripts in your sheet.

I am working on a questionnaire with radio buttons. Whenever I scroll through the sheet it gets all jumpy and jittery (for lack of better words - lol) and it's driving me crazy. I have tried the "Don't move, resize..." option but it doesn't help. Does anyone have any ideas on how to lock it down so the questionnaire doesn't look like a Mexican jumping bean whenever you scroll?

 

[BDD2015]

Hi
No, nothing like that. Strictly option boxes so far. No special formatting, no macros and no auto anything that I am aware of.

 

[mikerickson]

How many option buttons?

 

[BDD2015]

57 questions. Two blocks of questions. 5 in the first and 4 in the second.
New here but is there a way I can upload the file?

 

[My Aswer Is This]

We asked. How many option buttons.
You said 57 Questions....
So do you mean 57 option buttons?
What is a "Block"

If you have 57 questions and 5 option buttons per question that would mean about 250 Option buttons

When you say "Block" do you mean a "Frame" ?

 

[mikerickson]

Five options per question in the first block, 4 per question in the second block. That's a decent number of controls to be moving around.

Have you considered using Marlett option buttons, which turn cells into option buttons.

Put this in the code module for the sheet in question, and select a cell in columns A:E, note that above row 10 there are 5 options and below, there are only 4.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    With Target.Cells(1, 1)
        If (.Column <= 5 And .Row < 10) Or (.Column <= 4 And .Row < 20) Then
            Application.EnableEvents = False
            .EntireRow.Range("A1:E1").Value = vbNullString
            .Font.Name = "Marlett"
            .Font.Size = 14
            .Value = "a"
            .EntireRow.Range("F1").Value = .Column
            .EntireRow.Range("F1").Select
        End If
        
    End With
    Application.EnableEvents = True

End Sub

 

[BDD2015]

I guess the word is group box? Five in the first group and 4 in the second. For each of the 57 questions

 

[BDD2015]

never heard of a Marlett option button but I'm always willing to try and eager to learn. So here I go... Thanks

 

[BDD2015]

That's actually really cool but I can't see it. This questionnaire is for supervisors at work with zero to nil Excel experience and I think it would just freak them out, assuming I could do something with it to make it more visual.
What I have right now - using only 1 question as an example is -
On the same row, two group boxes - the first with 5 option buttons and the second group box with 4 option buttons.
Repeated 57 times, of course.
Very cool tho. When I have time I will definitely Google Marlett