Table of information in msgbox - EXCEL VBA

[mbsalim]

Hello helpful lot!,

So I have an excel sheet heavily 'macroed' and coded but need to insert a message box for when a particular worksheet is opened. there are two issues/questions;

1) How do I format the message box so it is over 3/4 lines and not one long text.

2) Within the message box I want to insert a table of information which is located on a hidden sheet (labelled SYS_Fee)

so far I have;

Private Sub Workbook_Open()

Dim msg As Long

msg = MsgBox("message", vbOKOnly, "Fee Disclaimer")


End Sub

What i would like is;

Private Sub Workbook_Open()

Dim msg As Long

msg = MsgBox("message blah blah blah:

table of information", vbOKOnly, "Fee Disclaimer")


End Sub

Thank you soooo much for your help in advance!!!!!!!!!!!!!!!

 

[Derek Brown]

The first argument for Msgbox would need to be a "concatenation" of values.
For example:

Msgbox "line 1" & vbcrlf & "line 2" & _
vbcrlf & "line 3" & vbcrlf & "line 4"

You could then add your table of information, one line at a time (you can also use "vbtab" for tabulation) but make sure that you do not have too many lines - you will want the message box to fit on the screen,