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

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

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

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

http://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
http://msdn.microsoft.com/library/en...FormsPartI.asp

Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Raza" wrote in message
...
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!

or some helper cells and buttons and msgboxs....
--
paul

remove nospam for email addy!



"Bob Phillips" wrote:

I think you are referring to a userform.

This will require some effort on your part. Start with

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

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

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

http://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
http://msdn.microsoft.com/library/en...FormsPartI.asp

Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Raza" wrote in message
...
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!

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

Bob

"paul" wrote in message
...
or some helper cells and buttons and msgboxs....
--
paul

remove nospam for email addy!



"Bob Phillips" wrote:

I think you are referring to a userform.

This will require some effort on your part. Start with

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

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

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

http://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

http://msdn.microsoft.com/library/en...FormsPartI.asp

Part II

http://msdn.microsoft.com/library/en...ormsPartII.asp


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Raza" wrote in message
...
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!