LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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.

Last edited by Bongo Boy : February 25th 12 at 01:59 AM
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Survey Form And Tracking Results Joe Gieder Excel Worksheet Functions 2 May 12th 09 05:15 PM
User Form for Survey sahafi Excel Programming 6 September 2nd 07 09:04 PM
How can one set up a survey form in Excel Janev New Users to Excel 6 September 22nd 06 08:54 AM
Can one set up a survey form on excel? Janev New Users to Excel 2 September 21st 06 02:15 PM
Survey Form John Excel Discussion (Misc queries) 1 September 26th 05 10:55 AM


All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"