Results 1 to 32 of 32

Colour and font size in message popup

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2009
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    24

    Colour and font size in message popup

    Hi,

    Ive had some great help making a code to force a pop up window to appear when i certain vailue is reaced in a particular row.

    the code is below

    Just wondering if itis possible to change the background colour of the message box (to RED as it is a critical warning) and to enlarge the font size as well



    THE CODE

    Dim B As Integer
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    A = Application.WorksheetFunction.CountIf(Range("B:B"), "HELD - Cargo is held under Customs control")
    If A = B Then
        Exit Sub
    Else
       B = A
       MsgBox String(10, vbLf) & String(50, " ") & "STOP DO NOT SELL" & String(50, " ") & String(10, vbLf)
    End If
    End Sub
    Last edited by JBeaucaire; 05-24-2013 at 10:29 PM. Reason: Added CODE tags, as per Forum Rules. Take a moment to read the Forum Rules in the menu bar above. Thanks.

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