Processing results to a worksheet

[tapsmiled]

Hi,
Two sets of circumstances:

1) I am making a UserForm, and when a Command Button is selected, I would like the information from ComboBox1 to be sent to a worksheet (Sheet One).....let's say into cell A1. The next time that form and combobox are filled, I want that information to go into the next available cell on the worksheet, in this case A2, and so on. This part is intended to track all results from the UserForm.

2) Same situation, but when the combobox is filled, I also want only certain answers ("Non-Satisfactory" for example) to go onto a separate worksheet (Sheet Two). This is to track specific trends.

Can anyone help? Thank you

[mehmetcik]

Ok

This code meets your first requirement.

Please Login or Register  to view this content.

Modified to meet Part 2

Please Login or Register  to view this content.

I never insert the results at the bottom, as the latest results are what you usually want to see.
So they should be at the top.

to do that

Please Login or Register  to view this content.

[tapsmiled]

Here, this is a bit more specific:

Please Login or Register  to view this content.

To this code, I want to be able to track any time a user selects "Non-Satisfactory" for a response for the ComboBoxes. Basically, I want to know the criteria that non-satisfactory was chosen so that I can track certain trends among employees.

The way I have prepared the TRENDS worksheet is that I have a column indicating DATE (A) then 17 columns B:R (1 for each of the ComboBoxes) where I intend the results to go. I only need to track the non-satisfactory answers. So, the first time a user SUBMITS the UserForm, =TODAY() will go into A2 then every time non-satisfactory is chosen, the number 1 will appear in that corresponding column between B2:R2. The next time someone SUBMITS that form, it will go into B3:R3 and so on. It would be great if I could compile all of the results by month, so I could produce a report saying, "For the month of January, the newest trend involves Dispatchers not verifying the address"-----since that is one of the criteria being scored via the ComboBoxes.

Does this make sense?

[tapsmiled]

@mehmetcik:
Thank you very much. Can you look at what I just posted please. Sheet 1 is called QA and Sheet 2 is called TRENDS. I can try to modify the code you provided if you can just give me a quick example of how to apply it here.

THANKS!!!!

[tapsmiled]

I modified it to my sheets, but it did not send anything to the TRENDS sheet. here is how I modified it:

Please Login or Register  to view this content.

[mehmetcik]

Your first Row should be titles. ie A1 must have something in it

Why did you use A2 and B2 instead of A1?, the offset does that for you.

Please Login or Register  to view this content.

[tapsmiled]

A1 is where I have the header DATE. B2 is just the first spot where I wanted the info to appear

[tapsmiled]

This is the worksheet where I want the information to go.

There are 4 different UserForms that will be supplying the information to this TRENDS sheet. If you look across the top of this worksheet, there is the title for DATE, then several other groupings of 14-17 columns. Each of these 4 groupings represents 1 of the 4 different UserForms. So, any time 1 of those forms is submitted, I want to be able to track the total number of instances when Non-Satisfactory was chosen for each question. This will simplify the process of recognizing Trends that need to be addresses with the staff (for training purposes).

I hope that makes sense.

Here is how I attached the code that you provided:

Please Login or Register  to view this content.

It seems to have slowed down the processing of the form submission, and it is not producing any results on the TRENDS sheet.

EDITED TO ADD: In case that wasn't clear, I'd like a "1" to appear in each of the corresponding boxes on the TRENDS sheet. B2 on the 911 Operator UserForm corresponds with TRENDS!ComboBox1, B3 is ComboBox2, etc. The FR Dispatcher UserForm ComboBox1 corresponds with S2 on the TRENDS sheet. The next time those forms are submitted, I want the info to go into Row 3, then Row 4.

[tapsmiled]

If this needs to be simplified, I can just create columns on the TRENDS worksheet and, instead of a single column for each question, I can just have the command button transmit the question number and the date.

Here's an example of what I m talking about. Once the information dumps to this TRENDS page, I would like to be able to pull the most frequently occuring instances where the Non-Satisfactory option was selected...highlighted on the Sample in yellow for the 911 UserForm and blue for the FR Dispatch UserForm.

[tapsmiled]

I tried this on a blank new sheet, and it didn't do anything.

[tapsmiled]

This is my most recent attempt:

Please Login or Register  to view this content.

The parts that appear in bold are what I added. I have tried .Value and .Text and nothing is producing a result. In fact, i am getting a debug error with the

Please Login or Register  to view this content.

line.

PLEASE HELP!!!!!