Hi all,

I was wondering if it was possible to put code inside the MsgBox object that would dictate what info the messagebox would display?

Description of project:

I have a userform that allows for the seriel entry of date, name, ***

This information is dumped into a hidden sheet where it is sorted on date (after clearing the columns of previously entered data)

I then have a loop that determines how many entries there are:

Dim M as Integer
Dim trmLoopsSize as Integer

Do
trmLoopSize = M
M = M + 1
Loop Until Woorksheets("Hidden1").Cells(M, "H").value = ""



Now, I can get each of the rows of data to output into their own message box with the code:

For M = 1 to trmLoopSize
MsgBox "Please review this data for entry: " & chr$(13) _
& chr$(13) _
& Worksheets("Hidden1").Cells(M, "H").Value _
& " " _
& Worksheets("Hidden1").Cells(M, "I").Value _
& " " _
& Worksheets("Hidden1").Cells(M, "J").Value _
& Chr$(13)
Next M


However, what I really want to happen is to have all that info in a single message box, but I can't seem to get the syntax right.

Any help would be most appreciated.

PS - how do you get indented text to work in a vB forum other than masking text placeholders with the background color?