Dialog box with worksheet information

[Guest]

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!

 

[Bob Phillips]

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-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp

Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

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

 

[Bob Phillips]

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


Bob