Program List boxes

Hi and welcome to the forum.
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

Have you considered Data Validation cells for capturing data? Once you've captured data you can use other cells to deduce things like related scores

I can't tell from your workbook how you actually use it or what any results should look like therefore please upload a version which shows what the data looks like when you have captured it and what any dependent cells should contain. And be sure to explain clearly how you arrive at the dependent cell values.

Hi julianhg,

I hope I got what you mean.

Maybe using a vlookup.
The user needs just one listbox for the frequency.

can you set up another field with a what if function like: if 1 then 0, if 2 then 1, ..., if 11 then 168?

Assuming that the "per month" you want to appear in column W, then in W6 put a formula =VLOOKUP(U6,I5:K15,3,FALSE)
and have column i (column helper) with a number from 1 to 11 starting from cell i5 to i15.

For example if the user choose "4-5x day" in the listbox,
then in cell U6 will have a value 10
and then in cell W6 (the one with the formula) will give a value 126.