Hello,

I am looking to develop an easy to use form in Excel that a user can input certain criteria and the output would provide an answer. The user would need to input the following: Qualitative or Quantitative, Sample Size (#), Test Criteria (#), Test Criteria Breadth (#), and Frequency(< or > Targeted), the output should result in Word, Excel, or ACES based on the Matrix below.

Scenario 1, Input Qualitative, Sample Size = <1, Test Criteria Size 1, Test Criteria Breadth 1, Frequency NA or doesn't matter, output = "Word"

Scenario 2, Input Qualitative, Sample Size = 1, Test Criteria Size = 1, Test Criteria Bandwith = 1, Frequency NA or doesn't matter, output = "Word"

Scenario 3, Input Quantitative, Sample Size = <100, test criteria size = 1 Test Criteria Breadth = 1, Frequency = NA or doesn't matter, OutPut = Excel

Scenario 4,Input Quantitative, Sample Size = >20, test criteria size >2 Test Criteria Breadth >=1, Frequency = NA or doesn't matter, OutPut = ACES

Scenario 5, Input Quantitative, Sample Size =NA, test criteria size = NA Test Criteria Breadth = NA, Frequency = >targeted , OutPut = ACES

message edited by phatguy85

I have absolutely no idea what you are asking for, please consider that you have probably thought about this many times but we have absolutely no idea what the concept is, start from the beginning and explain your requirement clearly. I am looking to develop an easy to use form in Excel that a user can input certain criteria and the output would provide an answerWhat answer? you second post have provided some scenarios but I don't quite see the answer, unless they are "Word", "ACES" or "Excel" but what do these answers mean? how to they output? where do they output?

lets start again.

I have put together the form that outputs WORD, EXCEL or ACES depending on the inputs you select from dropdown menus or enter into text boxes. I have no way of uploading a picture as image sharing sites are blocked in my office. I can send you the excel file if you pm me your email address.

Hello, based on my first post I am looking to provide a VBA user form in excel that when opening it prompts you to fill in or choose certain criteria. The criteria I listed 5 in my first post. First the User would choose "Qualitative" or Quantitative. This is a solution tool for determining the type of program to record targeted review results in, the programs are WORD, EXCEL, or ACES. So once all inputs are entered they should result in one of those three options. My Scenarios listed are the guidelines for the result. Example Scenario 1 the user chooses Qualitative enters 1 in as the sample size. Test criteria they enter a 1, and test criteria breadth they enter 1 in this scenario the frequency is not relevant since they had Qualitative, 1,1,and 1 the result is always Word. I need the other scenarios accounted for in the form so that when they choose Quantitative and input the other fields it returns the correct program. Does this help clarify at all?

I have sent you an email with what I have done, hopefully it meets the requirement, if there are changes required please post here to keep the thread updated. Thanks,

if I type free form numbers it doesn't result in the correct out put. Example: I chose Quantitative, with a size of 22 a test criteria of 3 and test criteria breadth of 2 with NA frequency, this came back with an error message when it should return ACES.

Excel should be returned if the user choose quantitative the sample size is less than 100 but test criteria are 1 and test criteria breadth is 1 with an unknown or NA frequency. another ACES Solution is a result of choosing Quantitative with an unknown or NA Sample size, unknown or NA test criteria size, unknown or NA test criteria breadth but the Frequency is more often than targeted or >targeted. does that makes sense? In my example I tried I would need it to work with free form numbers.

It looks great otherwise and the first two scenarios worked perfectly!

Just for clarification I sent phatguys85 an email with a workbook I created. Excellent, please continue to test, once you have satisfied please mark the thread as solved. thanks

Based on the scenarios above I have written some kind of logic to try and facilitate the form cases or scenarios.

Scenario 1&2 IF "combobox" = Qualitative and "Sample Size"=1 or <10 and "test criteria size = 1 or NA, and Test Criteria Breadth = 1 or NA and Frequency is "Blank" or NA…..if true it should return with the program WORD

Scenario 3 If "combobox" = Quantitative and "Sample Size" is <100 and "test criteria size is <=2 or NA, and Test Criteria Breadth = 1 and Frequency is "Blank" or NA…..if true it should return with the program = EXCEL

Scenario 4 IF "combobox" = Quantitative and "Sample Size" >20 and "test criteria size >2, and Test Criteria Breadth >= 1 and Frequency is "Blank" or NA…..if true it should return with the program = ACES

Scenario 5 IF "combobox" = Quantitative and Frequency = >Targeted Approach = ACES (all other inputs can be blank or NA this one is dependent on the combobox being Quantitative and the frequency being more often than targeted) if true it should return with the Program = ACES.

Just some advice for when posting, when you post your scenarios please can you either use the PRE tags or at least have a carriage return to space things out, I am struggling to read your posts as everything is squashed together. Re post #9

are you asking a question somewhere or was that just a FYI?

I figured it out, manipulated the logic you set up originally in a different nested if. Thanks!

Awesome glad it works for you and you were able to follow my logic and modify it to your needs :)

Ask Your Question

Weekly Poll