Survey Form as a Project

[Bongo Boy]

It always seems to be this way. I start with what I think is a simpl
little project, and I'm unable to accomplish anything at all withou
what seems like the need to learn 10 years of VBA programming. I shoul
probably begin with a classic "all I want to do is..." statement, so
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--i
returns a value to tell me which button was selected
e)...and here's the paisto resisto: I'd like not to have a GroupBo
border around the 3 to 7 option buttons.

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

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

 

[GS]

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