Change length of button texts on msgbox

That's an awful lot of code if all it's doing is showing a message box and controlling the size of the buttons!

Why not just create a userform that looks and acts like a message box and call that in stead? That way you can easily size the buttons how you want them.

BSB

Hi BadlySpelledBuoy,

thank you very much.
Yes i can do it via userform but maybe somebody knows windows hook class to do it in very simple way and provide solution.

Best Wishes,
Jacek

Thank you Rory!

hmm ok hmm it is possible to lock exit button on userform like in attached msgbox (it is turned off).

Best,
Jacek

small peace of code to do that..
see this page http://spreadsheetpage.com/index.php..._close_button/

Private Sub UserForm_QueryClose _
  (Cancel As Integer, CloseMode As Integer)
'   Prevents use of the Close button
    If CloseMode = vbFormControlMenu Then
        MsgBox "Clicking the Close button does not work."
        Cancel = True
    End If
End Sub

Thank you!

I am closing the topic

Best
Jacek