View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default Help with Message Box Please

Hi Everyone,

I have a Program that I Wrote Directly into a Module that Runs and
Lists Combinations. It Cycles through the Combinations ( Taking out
those that I Do Not Need ) and then Prints them out Starting in Cell
"A1" of the Active WorkSheet.
What I would like it to do is to Tell me How Many Combinations there
are to be Printed, and Give me the Option of Printing Them to the
Active Sheet Or NOT.
I Managed to get a Message Box that Just Gave me the Total
Combinations BUT it Still Printed them to the Active Sheet.

I have Already Tried in Different Parts of the Code :-
Dim Count As Long
Count = 0
Count = Count + 1
MsgBox Count

I Know I Need to use :-
vbYesNoCancel
Somehow, but I Do Not know How to.

I Would Ideally Like the Message Box to Say :-
There Are "x" Combinations That Meet The Criteria You Specified, Do
You Want To Print Them?.

Thanks in Advance
Paul