how to set a result based on a range of responses in a userform??

[NayB1980]

Hello,

I'm new to excel and have developed a userform by following google steps!!

I have a form that I want users to answer a series of questions which will give them a group allocation based on the answers they have provided in the form. However, I have no idea how to do this. I have looked at lots of pages and other issues people have posted, but most of it seems to be very different to what I'm after.
There are 4 possibilities that can result based on 5 questions - I have set them up as yes/no (for 4 questions) and greater than/less than (for 1 question) for ease of calculation.

I also want a 'site code' auto-generated by the choice that is made in a drop down list.

The point of this form is to allow diagnostic categories for a study! It doesn't need to be saved, only printed onto an A4 sheet to go in the patient file. I have managed to do this, and done a test print!

I set up the form to pop up when the 'click here' button is pressed, but I've read on other posts that you can set it just to open to the form. Can someone explain (very simply) how to do this please?!

Apologies for the 3 requests as it's probably a lot for a first post!

[Leith Ross]

Hello NayB1980,

welcome to the Forum!

To expedite a solution, you should post a copy of your workbook. This will allow all code to be tested against the actual data and layout. If your workbook contains sensistive information, please redact it before posting.


If you can post a copy of the workbook for review, it will help us find a solution faster.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

File Manger Picture


This code needs to be a VBA Module.

[NayB1980]

Apologies for not supplying it in my original thread - I wasn't sure if I should at the first post.

Upon playing with it a bit more, I've realised that my response options need to be check boxes rather than radio buttons, so I'll need to fix this, but the principle for getting the result on the form will be the same won't it?

[Leith Ross]

Hello NayB1980,

Where does the "Participant ID" come from? I don't see it anywhere on the UserForm.

[Leith Ross]

Hello NayB1980,

One other question, which button will log the entries?

[Leith Ross]

Hello NayB1980,

The UserForm will display when the workbook is opened.
I corrected the problem with the option buttons not working in pairs.
The Site List is now dynamic. Just add to the list on the sheet. There are no blank lines in the drop down.

[NayB1980]

Hello NayB1980,

Where does the "Participant ID" come from? I don't see it anywhere on the UserForm.

Hi Leith, the Participant ID is made up from the screening number & randomisation number that the user types into the form

[NayB1980]

Hello NayB1980,

One other question, which button will log the entries?

Hi Leith,

I haven't set it to log the entries as the idea is the user will input the data & print the form to be placed in the patient file. The form will be accessible via an online web-page that we have for all of our studies.
We have to have everything paper-based so I didn't see the point in saving the form because it won't be accessed for checking (hence why I've asked for it to be printed). Or does it need to be logged??

[Leith Ross]

Hello NayB1980,

Since your workbook has a "Data" worksheet with columns matching the UserForm entries, I thought perhaps you might want to log the entries.

[NayB1980]

Hi Leith,

Sorry I did that because the instructions on how to set up the userform told me thats what I neded to do! For what we need this form for, the entries don't need to be logged. So I'm guessing I can delete that sheet?

[Leith Ross]

Hello NayB1980,

No problem, you can delete the sheet.

[NayB1980]

Hi, I'm wondering if anyone has had any success in helping me to figure out how to do the calculations?