Userform option button help

**mecharissa** · 10-31-2012, 05:31 PM

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!

**Sean Thomas** · 10-31-2012, 07:25 PM

Hi hopefully you can use this in your form

Sean

**mecharissa** · 11-01-2012, 12:42 AM

Hi Sean,

That kind of works for what I need, but instead of having the totals at the bottom, how would I go about just assigning a range to an option button? That way if I have Small, Medium and Large employees, it'll select their range only. I'm not sure if I'm making sense at all. I'm still new to VBA.

Thank you so much for your help!