Need advice w/checkboxes

[Tjer101105]

Hi, this is my first post, I tried to find what I was looking for, but... no luck

I am trying to create a random generator, with specifications, the display allows you to choose different things which affect the randomly generated outcome.

I have composed a list of over 3,000 male names and 4,000+ female names, they are each on their own worksheets, labeled 'Male Names' and 'Female Names'

I got the generator to randomly select the names based on the choice of checking a box next to male or female, or leaving either blank or checking both. It works! I was excited about that...

But now I am stuck... I have multiple choices for narrowing down the possible age range to generate a random age from. I'd like to use radio buttons to do it, but I already have another area I need radio buttons for and I can't seem to get them to stay seperate, they all want to be connected together.

The way I've got it set up is using 'form' radio buttons to link to cells in the sheets and having the vb code reference the cells rather than the radio buttons, if there's an easier way to reference the results of the radio buttons, say, from the 'control' toolbar, I would love it.

Also how can I make two sets of radio buttons?

I'd just like some advice if possible, thank you very much!!
Jer

 

[erik.van.geit]

hello,Tjer101105
Welcome to the Board !!!!!

let's start with

Also how can I make two sets of radio buttons?

try this
create a frame (Forms-toolbar)
put "linked" option buttons in the frame
for each group you need another frame

in case you change your mind
if you would use option buttons from the Controls toolbar
hold shift and select several option buttons
set the Groupname property to the same name

kind regards,
Erik