Survey Collection - Up / Down Spin Buttons

Jul 10, 2014

I'm creating a spreadsheet to collect survey data and how I have it set up is this:

Question 1 is a simple yes/no/maybe question - it uses an ActiveX spin button that the user presses up/down to increase/decrease the total. It looks like this:

Private Sub Yes_SpinUp()
With Range("C3")
.Value = WorksheetFunction.Min(15000, .Value + 1)
End With
End Sub

Private Sub Yes_SpinDown()
With Range("C3")
.Value = WorksheetFunction.Max(0, .Value - 1)
End With
End Sub

Cell C3 is where I keep track of how many people answered yes

The button is called "yes" under the button properties

So basically, I have one privatesub for spinning the value up and down. It works fine and is easily copy-paste-able for other answers, it just takes up a lot of space. I'm wondering if there's code I can write to handle the up/down in one sub. If not, i'll stick with what I have.

View 6 Replies


ADVERTISEMENT

Tallying Survey Responses Using Macros, Buttons

Dec 13, 2004

I conducted a survey and want to tabulate the results in excel. There is a lot of paper, so I want to list each answer on the spreadsheet and have a button next to it to tabulate the responses instead of doing it by hand. When I look at each survey, I want to click the button for the corresponding answer. I want to have excel tally/increment each response each type I click the button.

So what macro do I need to assign to each button in order to do this? Or can I just click on a cell and have it increment? Or what can I do to achieve this?

My attempts have given my circular reference errors, or if I do the iteration thing (tools, options, iterations), excel increments EVERYTHING in the spreadsheet by one instead of just one specific question.

View 9 Replies View Related

Spin Buttons - Moving Columns

Nov 21, 2007

ive seen a spin button used to move hole rows up and down.

what i would like to do is.

I use cells I9-N9-S9-X9

can i use a spin button to move collums?

how do i write the code, say if i select cell S9 and i want to move it to I9 using the spin button how do i go about that?

View 9 Replies View Related

Analyzing S Survey Form

Apr 20, 2013

I would like to analyze a survey form.

See attached example : survey.xlsx‎

I am trying to display a total of answers per question and transform that into a grid for easy reporting but am not sure how to do it.

View 2 Replies View Related

Survey Form With More Than 2 Options

Apr 10, 2014

I followed a youtube video on setting up a survey in excel, and it works great, but it was only for two options. I wanted to make it 5 options per question, but when I started adding to the code ( which I thought was correct, but was not ) I kept getting errors. It probably is a simple addition. How to make the survey options more than two?

There are three tabs. The first tab (Start) only has a button that leads to the QA Survey. The Second tab has the questions and answers. The third tab as three columns in it as well for the name of the person, question number, and answer choice.

Here is the code inside the form (QASurvey):

Code:
Private Sub button_next_Click()
''confirm there is a name
If TextBox1.Value = "" Then
MsgBox ("Please enter your name")
[Code] ...

Here is the code in Module 1:

Code:
''global variables
Public info() As Variant
Public results() As Variant
Public questionnumber As Integer

Here is the code on the sheet that has the button to start the Survey Form:

Code:
Private Sub Start_Button_Click()
QASurvey.Show
End Sub

View 5 Replies View Related

Rank Questions In A Survey

Nov 7, 2006

I am trying to rank questions within a survey with excel calculations and not VBA. The rank would take place for each individual section and would provide the top three right questions and top three wrong questions. The example below explains the ranking.

Brief facts:
Each survey has up to 30 sections.

Each section has up to 150 questions.

Each question has none or no limt of sub-questions.(usually between 1 and 20, weekly changes require this number to change)

The section's number of questions change weekly with updates.

This week section 2 begins with #12, next week begins with #16 because more questions were added to section 1.

There are three possible choices to answer a question (yes, no, or n/a.)

Sub-questions are checkboxes of explanations on why the question could be answered wrong.

Each question may have 0-10 points assigned.

Each sub-question may have 0-10 points assigned.

When a question is answered "no" is when a sub-question may be checked to help explain why.

A question with sub-questions may only be assigned points at the sub-question level. The sub-questions have the points and do not sum up to total the question value.
When a question is answered "no" and a sub-question is checked, the points received are 0 points for that sub-question. Unchecked sub-questions receive the full amount of points.

When a question is answered "yes" all points are received.

The Rank:

The rank would take place for each individual section and would provide the top three right questions and top three wrong questions at the question level. My example below has more than three to help explain further.

Select the highest actual score of question or sub-question. Start with 10 points to 0 points.

When a match is found that becomes the first "correct" question rank. #17 is 1 since 17.1 had an 8 point sub-question.

When there is a tie #14,15,18, the tie breaker is the sum of correct sub-questions added to the question score. #14 = 7 points.

The second sort is the # in ascending order #15 and then 18.

The hardest part of the rank is the flexibility of a changing survey with question/sub-question deletions and additions in each section. ...

View 10 Replies View Related

Multiple Macro Buttons (radio Buttons)?

Feb 10, 2012

I am trying to create a worksheet that has multiple radio buttons. Each radio button is linked to a Macro. I need there to be many buttons running down one side of the worksheet. Each button needs to perform a macro that is relevant to the cells in the same row that it is on.

Essentially what i am trying to do is make a macro that when the button is pressed copys data from H6 and paste it into B6. The button is situated above I6. I need a button for each row from 6 to 110.

While this macro is easy to create (i use the record button and then assign the macro to the button), i would have to do this 104 times and assign a new macro to each button.

Is there a quicker way?

View 6 Replies View Related

Change The Color Of Buttons Or Command Buttons

Mar 14, 2007

Is it possible to change the color of buttons or command buttons? There does not seem to be any place that allows this under properties for buttons, although there does for command bars. However, I've tried recording a macro as I change the color, but nothing get's recorded so I'm not sure what the syntax would be.

I have a spreadsheet with several buttons and I'd like them to change colors as they are pressed so it's possible to see what you've already done. And then, as soon as any other cell on the sheet is changed, the buttons reset color.

View 9 Replies View Related

Survey Form - How To Open Another Thread

Jan 2, 2013

how to open another thread. I would like to do a survey form (as attached) but I wanted to use VBA to make it easy to compute the result.

View 2 Replies View Related

Extract Data From Survey Checkbox

Dec 11, 2013

I have a survey/form that was created in excel, and that is answered in excel. I am required to extract the data into a worksheet for each response received. I am able to pull the text that is entered, however i am having trouble pulling through the info from the checkboxes. So if a checkbox is ticked i cannot pull that through?

View 1 Replies View Related

Analyzing Survey Data In Excel

Apr 6, 2010

After survey questions and responses are in excel, how do you analyze this data using a correlation matrix and regression analysis for reporting or testing hypotheses?

View 3 Replies View Related

Sort Survey Data In Excel

Apr 4, 2013

I want to analyze a survey which I made. Below you see an example of how I structured the answers.

Now I would like to rank the answes (rows 2-6) in a list according to often each item was mentioned.

I could do transpose the data manually and delete items which were mentioned various times. However, since it was a pretty big survey, it would take to long. Is there a formula to do it?

Original:

Person A
Person B
Person C

Water
Water
Sugar

Washing
Washing
Pasta

Boxes
Milk
Water

Frozen
Vegs
Fish

Cleaning
Cheese
Water

Example of how it should look like:

Water
3 (times mentioned)
100% (because everone mentioned it)

View 3 Replies View Related

How To Organize Survey Data That Has 2 Choices

Nov 17, 2013

I did a survey of what kind of clothes people like to wear and why. So there are two things that people have to write down. ex) jeans and cus they're comfortable / shirts and cus they look good

The data that I received was organized as followed

I just put in random things just so you can get the idea of whats what

Id
jeans
shirts
cardigans

[Code].....

Okay so what I want to know is how I can get the responses from the data spreadsheet I showed you before into this organized data table above.

View 3 Replies View Related

Number Plate Survey Normalization

Mar 29, 2007

I have a list of vehicle number plates (or License plates for some of you) that have been recorded on a video camera and then converted to a text file using recognition software.

Unfortunately the records are far from 100% accurate so any data manipulation (travel times between points etc) becomes a bit dodgy and clumbsy to allow for this. I want to keep all of the data entries but need to identify each vehicle with a little more accuracy. I'm not worried about whether the plate number recorded is correct, only that it is the same for each instance that a particular vehicle is recorded.

The data comes in looking roughly like this:

ABC123
DEF456
AC13
A123
DE56
DEF56

I would like it to look like this:

ABC123
DEF456
ABC123
ABC123
DEF456
DEF456

Or even this:

AB123
DF45
AB123
AB123
DF45
DF45

It doesn't matter which of the above or any other compination as long as there are at least 4 characters.

The surveys are taken over up to a week so there are generally about 5000 records for each time slot that need to be processed.

I have tried to modify the Fuzzy matching functions with no success.

View 9 Replies View Related

Survey Results In Pivot Table

Jul 25, 2007

I have just recently finished inputting data into a spreadsheet which is a whole bunch of survey responses and I am trying to figure out the best way of now “analysing” it. Unfortunately the questionnaire consists of various types of questions, including some open ended, some where the participant selected a number on a scale, or the participants could select any number of options (e.g. tick any that apply).

From a brief search, I see that you can’t have two headings as such for a pivot table so I am wondering what the best approach might be. I have attached a sample spreadsheet. I have a hunch though that it’s going to be a matter of analysing each question individually and using filters and countif formulas (see attached).

View 2 Replies View Related

Spin Button

Dec 16, 2008

i want a spin button to decrease the value on a cell into negative numbers.

In other works, if cell a1 has a value of 10, i want the down arrow on the spin button to make the 10 decrease down to 0 , then -1,-2,-3 and so on .

View 9 Replies View Related

Survey Results Table Lookup Errors?

Jun 26, 2014

An offset sumproduct series of functions provides me the total score percentage for the top level categories. There are 5-6 in total and can easily be charted in a radar.

The second step is to maintain the 'dynamic aspect' (being able to delete rows) and lookup the high-level category, and the subsection and return the score for the individual question. This way I can create a chart for each of the 5 top level categories and show the survey score for each answer in the category. Note each question has a maximum score of 5 and are scored 1-5.

I have a few errors looking up values and percentages coming back as 500% with the addition of new columns (in red in attached). The first sheet is error free, the second sheet is the 'build'.

Note: Charts will be housed on a separate sheet.

View 1 Replies View Related

Excel 2003 :: Tabulating Survey Results

May 27, 2014

Is there a way to show the results of a survey (basic y/n) as a percentage of total surveys submitted?

I have also been charged with keeping the customer data (name/house number) visible when it's displayed as a chart?

Attached is a sample : sample.xls

Excel 2003 btw...

View 3 Replies View Related

Array Or Countifs For Counting Survey Responses

Nov 4, 2009

I have recorded the data from 12 records (i actually have hundreds, but im just using a small sample). Each record is represented by a vertical column. I want to find the total number of "x's" for only the records from Country1 (from all the answers). Then I want to find the number of "x's" from only Country2. I have tried the "countifs" function but cannot find a way to make it work. Would a different array function be better? How would I write it?

P.S. The answer for Country1 should be: 15.
The answer for Country2 should be: 5.

View 10 Replies View Related

Selecting Latest Date (Particular Type Of Survey)?

Mar 18, 2013

I have a spreadsheet which has a list of properties with a list of survey dates. The complication is that every property has multiple surveys and these are all on separate lines with the spreadsheet. The number of surveys could also be different depending on the property in question.

What I would like to do is to compile a report which only shows me when the latest particular type of survey (there are five types of survey, I'll call them 1, 2, 3, 4 and 5).

The survey type is shown in column C, the property is shown in column A and the survey date is shown in column F.

View 4 Replies View Related

Delete Row With Spin Button?

Jul 12, 2014

I'm using the below code which only clears the data, I'd like to find a way to delete the row and also shift the row up.

[Code] ......

View 14 Replies View Related

Userform Spin Button

Sep 13, 2009

I'm using a form to display records based on a value YSNumber using this

Set tbl = Sheet1.Range("A:A")
Set fnd = tbl.Find(What:=cbo_YSNumber.Value, After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False)
fnd.Activate
Then I display reccord data by populating labels like this:


Label_RequestInstructionID.Caption = ActiveCell.Offset(0, 3)
Label_SchemeTitle.Caption = ActiveCell.Offset(0, 4)
Label_PMO.Caption = ActiveCell.Offset(0, 5)
I'd like to use the spin button to allow the user to cycle up or down the records.

View 9 Replies View Related

Spin Button Macro

Feb 6, 2010

I don't know much about VBA, but I am sort of working my way through. I have inserted a spin button in an excel sheet and assigned it to the following code in a module:

Sub SpinbuttonD4()
Range("D4").Value = Range("D4").Value + 0.01
End Sub

So, now when I click the spin button (either the up arrow or the down arrow), the value in D4 increases by 0.01.

What I actually want to do, however, is for the value in D4 to increase by 0.01 when I click the up arrow, and decrease by 0.01 when I click the down arrow.

View 9 Replies View Related

Create A Formula To Average Survey Results Per Instructor?

May 28, 2014

I am trying to come up with a good way to average a particular question in a survey result for instructors, however the caveat has me pretty puzzled. We're looking to be able to filter by mm/dd/yyyy date (which pulls mm/dd/yyyy hh:mm from raw data) and then have one average of all scores for each instructor listed. It gets a bit complicated in that the actual survey has 6 drop down boxes with all the instructors names, so one instructor could have data for the same (or any) date in any of the 6 colored columns (name, score, qualitative x 6).

My initial thought was to list out the names on a second sheet and then have some sort of averageifs to combine the columns, but I am a bit lost on how to take the dates into account, let alone how to sum the columns then average.

View 2 Replies View Related

Auto Increment Using Spin Button?

Jun 11, 2014

can i link a spin button to a toggle button such that when i click my togglebutton On then the Spin Button causes the Value in a cell to increment from 0.1.2.3.4.5 and when i click the toggle button off then value decrements from 5.4.3.2.1.0

View 2 Replies View Related

Spin Button Link To Another Cell

Feb 23, 2008

how to linked the "small change" value in a spin button to take the value of another cell?

View 12 Replies View Related

Spin Button Event Handling

Nov 26, 2008

The issue I'm having is with the ActiveX Spin Button (in 2007, formerly in the Control toolbox in 2003). I need the Spin Button to call a certain macro whenever it is clicked up or down. I know how to do this with one spin button, the problem is that the workbook I'm creating could potentially have dozens (or even hundreds) of these spin buttons that all need to call the same macro. It doesn't seem feasible to have to create separate Change event functions for each of these.

My company used to use the simpler form controls for this process, but a situation has come up where we need the ability to make the buttons invisible, or at least appear disabled, and that doesn't seem doable with the form controls.

So my question is, is there a way to specify in my workbook that whenever a spin button is clicked, this particular macro is to be called? Or even, whenever an ActiveX object is clicked, call the macro, because the spin buttons will be the only ActiveX objects in the workbook. I've read a bit about how to create global event handlers for worksheets and workbooks, but I can't find anything related to spin buttons specifically.

View 11 Replies View Related

Spin Button To Select Cells

Nov 17, 2006

I need some help using the spinner tool (the 2 way arrows) as a macro. I want it to point to different cells after each press. So, basically:

Click down once, go to cell A5
Click down again, now go to cell A6
Click down again, now go to cell A7
Clicking down again won't do anything, A7 is the end of the road

And the same thing backwards when clicking up.

I use the two commands SpinButton1_SpinDown() and SpinButton1_SpinUp(). I put the Range("A5").Select, etc. as the code. I don't know how to do the incremental part. I need a counter in there...

View 8 Replies View Related

Link Text Box & Spin Button

Dec 12, 2007

I have 6 text boxes on 5 different tabs all with their own spin button that will push the number up or down, starting from the default value. How do i lock/restrict the text box entry so, the spin button is the only way of changing the value?

View 2 Replies View Related

Making Sure An Option Button Has Been Selected Within A Group Before Exiting Survey

Nov 26, 2009

I have a survey with different groups of Control Toolbox options buttons on it. I want to ensure that each question has an option button selected before the survey can be exited and emailed onwards. The grouped button names are: GroupA, Group1 through to Group6.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved