+ Reply to Thread
Results 1 to 5 of 5

MsgBox with custom buttons

  1. #1
    Forum Contributor
    Join Date
    09-19-2014
    Location
    Michigan
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    145

    MsgBox with custom buttons

    How could I make a message box wit buttons labeled "3/36" and "COPVE"?

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: MsgBox with custom buttons

    Easiest way would be using a form
    多么想要告诉你 我好喜欢你

  3. #3
    Forum Contributor
    Join Date
    09-19-2014
    Location
    Michigan
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    145

    Re: MsgBox with custom buttons

    How do I do that? Sorry still trying to learn.

  4. #4
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: MsgBox with custom buttons

    You can probably Google for some instructions, my words would be boring.

    In VBA editor, right click on your workbook on the project explorer (left panel), and Insert -> UserForm.
    From the toolbox, select a Label, and place it in your new form. This would be used to display your message (to serve as a message box).
    Now select Command Button and place two of them in your form. You can then manually change the display text on these buttons.
    Now in your original code that displays the message box, most likely using MsgBox, use UserForm1.Show to display the form instead.

    This starts you off, however, for better and clearer instructions I suggest Googling.

  5. #5
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: MsgBox with custom buttons

    Quote Originally Posted by OpOrange View Post
    How could I make a message box wit buttons labeled "3/36" and "COPVE"?
    Try reading one of my old threads http://www.excelforum.com/excel-prog...using-api.html

    Works for me.
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Set custom Buttons on standard MsgBox using API
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2013, 02:57 AM
  2. [SOLVED] Getting yes & no buttons to work in MsgBox
    By shiftyspina in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-02-2013, 03:04 PM
  3. msgbox/inputbox with worksheet name radio buttons?
    By compulsiveguile in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2008, 12:40 PM
  4. Custom buttons in a msgbox
    By treva26 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2007, 01:49 AM
  5. How Do I Get Custom Captions For MsgBox Buttons
    By Minitman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-20-2006, 12:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1