+ Reply to Thread
Results 1 to 5 of 5

Custom Message Box VBA

  1. #1
    Registered User
    Join Date
    06-13-2016
    Location
    Cambridge,ON
    MS-Off Ver
    2013
    Posts
    9

    Custom Message Box VBA

    I want to create a message box that has custom options a user can select as opposed to the standard Yes/No, OK/Cancel etc. options.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Custom Message Box VBA

    Hi and welcome to the forum.

    In that case I'd be inclined to design your own VBA UserForm and incorporate whatever checkbox, optionbox, commandbutton..objects etc. that you need.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    06-13-2016
    Location
    Cambridge,ON
    MS-Off Ver
    2013
    Posts
    9

    Re: Custom Message Box VBA

    Thank you very much. I created the user form to print out a number depending on the selected option. Although the number prints the userform message box stays on the screen. Any idea how to remedy the situation?

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Custom Message Box VBA

    Hi,

    You need an
    Please Login or Register  to view this content.
    instruction.

    Either immediately after the printing instruction in your current macro, or in the click event of a CommandButton on the form itself.

  5. #5
    Registered User
    Join Date
    06-13-2016
    Location
    Cambridge,ON
    MS-Off Ver
    2013
    Posts
    9

    Re: Custom Message Box VBA

    Thank you very much for the help that worked perfectly. So I want all the inputs that the user enters to be added up in the end and print out for the user (it is a cost estimate). Do you have a way that you would recommend doing this?

+ 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. Custom message with mouseover
    By raihaan9 in forum Excel General
    Replies: 7
    Last Post: 07-01-2012, 01:07 PM
  2. Adaptive Custom Message Box
    By paxile2k in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-23-2010, 08:33 PM
  3. Custom Message on Open
    By viruzman in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-13-2009, 01:01 PM
  4. custom error message
    By JChandler22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2009, 12:15 PM
  5. custom message box
    By gobbolino in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-13-2007, 12:12 PM
  6. [SOLVED] replace VBA run-time error message with custom message
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-14-2006, 11:05 AM
  7. Replace Excel Message w/Custom Message
    By Kevin R in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2006, 11:15 AM
  8. [SOLVED] Use custom message
    By Pat in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2005, 09:06 PM

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