Need advice w/checkboxes

Tjer101105

New Member
Joined
Dec 23, 2005
Messages
1
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
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,388
Messages
5,571,847
Members
412,420
Latest member
grace_abar
Top