Check box or to not check box

[dmichael66]

I am trying to create a basic spreadsheet in MSExcel used to collect standard info (Name, address blah blah blah). The people who will complete this will need to classify the people they are listing into groups (Group A, Group B etc. 5 groups total) and each group will be listed on a separate tab of the workbook (maybe this isn't the best way?).

As they enter the people they will need to decide if the person they are adding is to receive the welcome kit. Each company is limited to 50 welcome kits. My thought is to use a check box for them to indicate yes or no on the welcome kit.

Is there a way to display the number of welcome kits that are remaining on whatever tab they happen to be on?

Is there a way to give a clear indicator next to each name that 'yes' has been selected (colored box, text?).

While I am fairly savvy with most software this is a little outside of my range so explanations written for a 10 year old would be helpful. Thanks.

 

[lenze]

You can use a simulated checkbox. See my VBAExpress KB article CheckBox Alternative

lenze