Survey Form as a Project
 

It always seems to be this way. I start with what I think is a simple little project, and I'm unable to accomplish anything at all without what seems like the need to learn 10 years of VBA programming. I should probably begin with a classic "all I want to do is..." statement, so I guess I will.

I'd like to have:

a) an Excel spreadsheet file, one tab per survey sheet
b) each tab has several survey questions or statements, and
c) below each statement or question is a group of 3 to 7 option buttons
d) each group of buttons does exactly what you might expect it to do--it returns a value to tell me which button was selected
e)...and here's the paisto resisto: I'd like not to have a GroupBox border around the 3 to 7 option buttons.

I've succeeded in getting all the way down to e) (using Form control OptionButtons), where all progress has stopped. I've run into recommendations to use a panel control (doesn't appear to exist in Excel 2007), create my own GroupBox having a settable bordercolor property, and I think the other one was to simply select the controls belonging to a control group and ensure they each have the same Groupname. The 1st and last of these options were either not applicable or didn't work for me, the 2nd option seemed like a long way to go to get rid of a border.

Where would you suggest I start, with the goal of having the project working before the decade is out? I have Walkenbach's Excel 2007 Power Programming and, apparently, a dim wit.

Survey Form as a Project
 

Bongo Boy has brought this to us :
It always seems to be this way. I start with what I think is a simple
little project, and I'm unable to accomplish anything at all without
what seems like the need to learn 10 years of VBA programming. I should
probably begin with a classic "all I want to do is..." statement, so I
guess I will.

I'd like to have:

a) an Excel spreadsheet file, one tab per survey sheet
b) each tab has several survey questions or statements, and
c) below each statement or question is a group of 3 to 7 option buttons
d) each group of buttons does exactly what you might expect it to do--it
returns a value to tell me which button was selected
e)...and here's the paisto resisto: I'd like not to have a GroupBox
border around the 3 to 7 option buttons.

I've succeeded in getting all the way down to e) (using Form control
OptionButtons), where all progress has stopped. I've run into
recommendations to use a panel control (doesn't appear to exist in Excel
2007), create my own GroupBox having a settable bordercolor property,
and I think the other one was to simply select the controls belonging to
a control group and ensure they each have the same Groupname.

Where would you suggest I start, with the goal of having the project
working before the decade is out? I have Walkenbach's -Excel 2007 Power
Programming- and, apparently, a dim wit.

Well, to begin with I wouldn't use option controls. Instead, I'd use DV
dropdowns so users can 'select' the options, and only have to check the
cell value to see what option was chosen. This is easier than looping
through all the controls to find which one was chosen, AND it's a lot
more efficient from a programming standpoint to just ref one cell per
option group. So..., I think you should redesign your form so that it
requires a few controls as possible (zero would be great!).

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion