Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. Last edited by Bongo Boy : February 25th 12 at 01:59 AM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Survey Form And Tracking Results | Excel Worksheet Functions | |||
User Form for Survey | Excel Programming | |||
How can one set up a survey form in Excel | New Users to Excel | |||
Can one set up a survey form on excel? | New Users to Excel | |||
Survey Form | Excel Discussion (Misc queries) |