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!

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!
>

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!

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" <(E-Mail Removed)> wrote in message
news:%238TM9OQ%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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!
>>
>