Message Box to display a variable number of rows

[TheShaunMichael]

Hi all,

Have a macro that generates a table of data 6 columns wide and 1+ rows long (usually no more than 10).

Want to create a message box that displays the data and maintains the table structure.

Thank you!

Shaun

 

[gmazza76]

The only way i can think that may show this information is on a userform listbox

I use a similar userform to say how many unanswered enquiries there are for a department.

If this is what you want i can post the VB.

Cheers

 

[TheShaunMichael]

Yes that works! I just set it up. Unsure why I didn't think of it. Thank you!