+ Reply to Thread
Results 1 to 6 of 6

Calling macro and ignore vbYesNo msgbox

  1. #1
    Forum Contributor
    Join Date
    07-20-2012
    Location
    Kingdom of Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Calling macro and ignore vbYesNo msgbox

    HI,

    i have the following:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    How can i ignore vbYesNo msgBox when i call Test macro? ("Executed" displayed without pressing Yes)

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,628

    Re: Calling macro and ignore vbYesNo msgbox

    Perhaps:
    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    or... please describe in other words what do you mean by
    ("Executed" displayed without pressing Yes)

    for instance if you want modeless msgbox then answer is no_way - either use modeless userform whicz mimmics msgbox or see http://www.tek-tips.com/faqs.cfm?fid=4699
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    07-20-2012
    Location
    Kingdom of Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Re: Calling macro and ignore vbYesNo msgbox

    Hi Kaper,

    Tank you for your replay, and sorry for my weak description,

    Please Login or Register  to view this content.
    it is existing macro, i don't want to change its code

    only i want to bypass the VBYesNo msgbox when i call it.

  4. #4
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Calling macro and ignore vbYesNo msgbox

    Not sure how you want to run different code without changing it!!

    If you're not comfortable changing it you could comment out the If line and the End if line by placing an apostrophe ' before the line and that line won't run
    Happy with my advice? Click on the * reputation button below

  5. #5
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Calling macro and ignore vbYesNo msgbox

    Hi,

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Or in a standard module:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Last edited by HaHoBe; 12-13-2014 at 04:08 AM.
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  6. #6
    Forum Contributor
    Join Date
    07-20-2012
    Location
    Kingdom of Saudi Arabia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Re: Calling macro and ignore vbYesNo msgbox

    Thank you Crooza and HaHoBe

    HaHoBe, you understand me and give what i want, You are CLEVER.

+ 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. Msgbox vbYesNo if then
    By Swoootie in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-24-2014, 09:22 AM
  2. [SOLVED] Having trouble with msgbox vbYesNo
    By Tayjayt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-25-2013, 12:55 AM
  3. msgbox vbyesno
    By newbielondon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2012, 06:25 PM
  4. VBA - on a vbYesNo, Yes needs to check data before calling macro
    By ez08mbba in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2012, 09:24 PM
  5. MsgBox vbYesNo and Exit Sub
    By Monkeyboyz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2010, 12:46 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