Hello everyone,

I have a quick question. I have a userform all laid out but now I'm trying to link a range to the optionbuttons selected and average them.

For example,

If the user selects the "Small" option button, it will select range "A4:A153"
Then if the user selects the "Amount" option button, it will select the range that the "Small" employee's "Amount"s fall under so, "C4:C153"

After the user selects "Small" and "Amount" and enters "OK" then I need to write a code to average the "Amounts" then display a message that states, "The Small employees averaged "Amount."

I already have the userform built, I'm just confused on how to write a code that takes the options the user selected and finds the averages.

If anyone has suggested they would be greatly appreciated. Thanks!