what alternatives do I have to msgbox??
 

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!

what alternatives do I have to msgbox??
 

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

"bliten_bsas" wrote in message
ups.com...
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!

what alternatives do I have to msgbox??
 

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

bliten_bsas wrote:
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!

what alternatives do I have to msgbox??
 

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

"RB Smissaert" wrote in message
...
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

"bliten_bsas" wrote in message
ups.com...
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!