software

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!

I think you are referring to a userform.

This will require some effort on your part. Start with

www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

support.microsoft.com/default.aspx?kbid=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97

Peter Aiken Articles:
Part I
msdn.microsoft.com/library/en...FormsPartI.asp

Part II
msdn.microsoft.com/library/en...ormsPartII.asp--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Razaquot; gt; wrote in message
...
gt; I would like to make a macro that creates a dialog box with information
from
gt; the worksheet.
gt;
gt; I have a membership database and I would like to have the dialog box show
a
gt; summary of how many female members, male members, the breakdown of
different
gt; types of memeberships.
gt;
gt; I know that you can use a countif to get the numbers but how would those
gt; numbers get into a dialog box?
gt;
gt; Thanks!
or some helper cells and buttons and msgboxs....
--
paul

remove nospam for email addy!
quot;Bob Phillipsquot; wrote:

gt; I think you are referring to a userform.
gt;
gt; This will require some effort on your part. Start with
gt;
gt; www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
gt; Lesson 11: Creating a Custom Form
gt; Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
gt;
gt; support.microsoft.com/default.aspx?kbid=161514
gt; XL97: How to Use a UserForm for Entering Data
gt;
gt; support.microsoft.com/default.aspx?kbid=213749
gt; XL2000: How to Use a UserForm for Entering Data
gt;
gt; support.microsoft.com/default.aspx?kbid=168067
gt; File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
gt; Controlling UserForms in Microsoft Excel 97
gt;
gt; Peter Aiken Articles:
gt; Part I
gt; msdn.microsoft.com/library/en...FormsPartI.asp
gt;
gt; Part II
gt; msdn.microsoft.com/library/en...ormsPartII.asp
gt;
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Razaquot; gt; wrote in message
gt; ...
gt; gt; I would like to make a macro that creates a dialog box with information
gt; from
gt; gt; the worksheet.
gt; gt;
gt; gt; I have a membership database and I would like to have the dialog box show
gt; a
gt; gt; summary of how many female members, male members, the breakdown of
gt; different
gt; gt; types of memeberships.
gt; gt;
gt; gt; I know that you can use a countif to get the numbers but how would those
gt; gt; numbers get into a dialog box?
gt; gt;
gt; gt; Thanks!
gt;
gt;
gt;

That may be more pragmatic Paul, but he specifically mentioned a dialog box
:-)

Bob

quot;paulquot; gt; wrote in message
...
gt; or some helper cells and buttons and msgboxs....
gt; --
gt; paul
gt;
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; I think you are referring to a userform.
gt; gt;
gt; gt; This will require some effort on your part. Start with
gt; gt;
gt; gt; www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
gt; gt; Lesson 11: Creating a Custom Form
gt; gt; Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
gt; gt;
gt; gt; support.microsoft.com/default.aspx?kbid=161514
gt; gt; XL97: How to Use a UserForm for Entering Data
gt; gt;
gt; gt; support.microsoft.com/default.aspx?kbid=213749
gt; gt; XL2000: How to Use a UserForm for Entering Data
gt; gt;
gt; gt; support.microsoft.com/default.aspx?kbid=168067
gt; gt; File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
gt; gt; Controlling UserForms in Microsoft Excel 97
gt; gt;
gt; gt; Peter Aiken Articles:
gt; gt; Part I
gt; gt;
msdn.microsoft.com/library/en...FormsPartI.asp
gt; gt;
gt; gt; Part II
gt; gt;
msdn.microsoft.com/library/en...ormsPartII.asp
gt; gt;
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Razaquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I would like to make a macro that creates a dialog box with
information
gt; gt; from
gt; gt; gt; the worksheet.
gt; gt; gt;
gt; gt; gt; I have a membership database and I would like to have the dialog box
show
gt; gt; a
gt; gt; gt; summary of how many female members, male members, the breakdown of
gt; gt; different
gt; gt; gt; types of memeberships.
gt; gt; gt;
gt; gt; gt; I know that you can use a countif to get the numbers but how would
those
gt; gt; gt; numbers get into a dialog box?
gt; gt; gt;
gt; gt; gt; Thanks!
gt; gt;
gt; gt;
gt; gt;