what alternatives do I have to msgbox??

[bliten_bsas]

Hi all, I'm trying to post a disclaimer in a financial model through a
msgbox that pops up when opening an excel file. The problem I have is
that the msgbox has a space limit of 1024 characters which I'm afraid
is not long enough. What alternatives do I have??? Thanks a lot!

 

[RB Smissaert]

You can download a custom msgbox from this site
that hasn't got that limitation plus has a lot of other useful features:

http://makeashorterlink.com/?V20531C0E

RBS

 

[Sandy]

You can make a splash screen using a user form... a quick example:

Place in the sheets Sheet level module:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
UserForm1.Show
End Sub


Create a userform and create a label and type some text
then place this code in the userform code

Private Sub Label1_Click()
UserForm1.Hide
End Sub
Private Sub UserForm_Click()
UserForm1.Hide
End Sub

HTH

Sandy

 

[RB Smissaert]

Just noticed that the zip file doesn't contain the compiled dll.
Will add this, but it will take a while to come through the website.

RBS