+ Reply to Thread
Results 1 to 2 of 2

searching for Full syntaxis form Msgbox helpfile en response code

  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    70

    searching for Full syntaxis form Msgbox helpfile en response code

    Dear reader,

    The following is my problem:

    [CODE]
    Sub boxjes()

    MsgBox "Waarschuwing", vbYesNo, "Het Beheer", "C:\Bureaublad\Help.hlp", 1000,

    If response = vbYes Then
    MyString = "Yes" (following code)

    Else

    MyString = MyString = "No" (following code)

    End If

    End Sub
    [CODE]




    I came no further than this.
    The anwser lies i think in the path of the help file however i don't succeed. (is called for the test "Help.hlp".

    And the response to vbMsbBoxResult is a mysterie to me.

    I have searched in books en the net but i dont see it. Or i missed it?

    Can you help me?

    Blake20

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: searching for Full syntaxis form Msgbox helpfile en response code

    The path to your help file is more likely something like this.
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. how to pop-up the msgbox when the searching mismatches
    By VBAidot in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-06-2016, 01:29 AM
  2. Replies: 19
    Last Post: 09-05-2016, 03:24 PM
  3. Run code with MsgBox Response
    By Sgt Rock in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-08-2014, 10:25 AM
  4. [SOLVED] Worksheet does not become the active 1 using .Activate function based on MsgBox response
    By thelisa in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-15-2013, 04:55 PM
  5. Code for searching a worksheet and displaying results in a form for editing
    By RossN in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2012, 04:18 PM
  6. User Form Buttons: Delayed response
    By 20 Ton Squirrel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-28-2010, 02:13 PM
  7. MsgBox response
    By Sunflower_Queen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2005, 05:08 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