Use 4th button in msgBox for ignore with vbYesNoCancel

  • Hey gurus,


    I've read in a few places that it is possible to use up to FOUR buttons in the msgbox API. I am trying to figure out how to use that fourth button but I don't see how to do the sum value for the "buttons" argument in the function call. I'm trying to use the vbYesNoCancel with an additional vbIgnore button option.


    here's my code and what I'm trying to do:



    I can make a user form if needed, but I want to know if this fictitious fourth button is usable before I go through the trouble.


    cheers!
    Nate

  • Re: Use 4th button in msgBox for ignore with vbYesNoCancel


    AFAIK the 4th button is a Help button... and the standard MsgBox can only use the pre-defined button combinations.


    It is possible to use the API to change the button captions, but this is way beyond the scope of this board and is generally not worth the effort for general applications.


    The simplest way to generate a 'custom' msgbox is to use a userform with code to show/hide, and set the caption of, as many buttons as you want.

  • Re: Use 4th button in msgBox for ignore with vbYesNoCancel


    Hey guys,


    I kind of figured that the UserForm was going to be the answer. I have seen some example code of updating the API and I'm really not interested in doing that at all.


    Thanks for the confirmation!
    Nate

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!