+ Reply to Thread
Results 1 to 3 of 3

Msgbox background color

  1. #1
    Registered User
    Join Date
    02-15-2006
    Posts
    93

    Msgbox background color

    Good afternoon,

    Quick question. Is it possible to change the formatting of a message box? Specifically, the colors - background and text color?

    I.e. Change the background color to blue and text to white for the following message box

    Sub ConfirmDelete()

    Msg = "You have chosen to delete the current record."
    Msg = Msg & vbCrLF &vbCrLF
    Msg = "Are you sure that you want to delete this record?"
    Config = vbYesNo + vbExclamation
    msgreturn = msgbox(msg,config)

    If msgreturn = vbyes then
    Rows(activecell.row).delete
    ElseIf msgreturn = vbno then
    userform1.show
    End if
    End sub

    Thanks to everyone in advance!
    dw

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    The short answer is No ...
    It is much easier to design your own user form to replicate the MsgBox ...

    HTH
    Carim
    Last edited by Carim; 11-30-2006 at 05:38 AM.

  3. #3
    Forum Contributor
    Join Date
    06-02-2005
    Location
    India
    MS-Off Ver
    2007
    Posts
    138
    See this link:
    http://www.h3.dion.ne.jp/~sakatsu/kt...es_English.htm



    HTH
    ilyaskazi

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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