I would like to make a macro that creates a dialog box with information from
the worksheet.

I have a membership database and I would like to have the dialog box show a
summary of how many female members, male members, the breakdown of different
types of memeberships.

I know that you can use a countif to get the numbers but how would those
numbers get into a dialog box?

Thanks!