+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : msgbox

  1. #1
    Registered User
    Join Date
    01-19-2012
    Location
    mauritius
    MS-Off Ver
    Excel 2007
    Posts
    3

    msgbox

    hi, i need some help. i want to make a mgsbox with icon like exclamation icon but while using vbExclamation i can't use vbYesNO at the same time. is there some kind of symbol that i need to insert to make both work simultaneously?

    there is my code


    Sub message1()
    reponse = MsgBox("Do you want to continue?" & Chr(10) & Time, vbExclamation, VbMsgBoxStyle = vbYesNo, "Question de vie ou de mort")
    If reponse = 7 Then Exit Sub
    response = MsgBox("Are you sure you want to continue?", vbYesNo, "Question de vie ou de mort")
    If response = 7 Then Exit Sub
    MsgBox "Then die!"
    End Sub
    Last edited by titishox; 01-20-2012 at 06:18 AM.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: msgbox

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-19-2012
    Location
    mauritius
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: msgbox

    thanks mate

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: msgbox

    Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.


    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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