+ Reply to Thread
Results 1 to 5 of 5

Cancel Button Inquiry

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Cancel Button Inquiry

    How do I update a cancel button so that when it is clicked it DOES NOT OPEN the VB editor screen?

    And where would I put the code?

  2. #2
    Forum Contributor
    Join Date
    02-24-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    317

    Re: Cancel Button Inquiry

    Would you please clarify what you mean by DOES NOT OPEN THE VB EDITOR?
    Are you getting a debug message?

    What is the code you currently have?
    Please post it.
    If I helped in any way, please click the star

  3. #3
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Cancel Button Inquiry

    Quote Originally Posted by Jim885 View Post
    Would you please clarify what you mean by DOES NOT OPEN THE VB EDITOR?
    Are you getting a debug message?

    What is the code you currently have?
    Please post it.
    the Visual Basic Editor opens up and a section of the code is highlighted. I want the cancel button to just return the user to the workbook

  4. #4
    Forum Contributor
    Join Date
    02-24-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    317

    Re: Cancel Button Inquiry

    That still tells me nothing, except now I know that you are getting an error message. I'm not going to guess at what you need, because there could be several answers. So you need to post the code you have. That way, I or someone can help you.

  5. #5
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Cancel Button Inquiry

    What is the code that is causing the error?
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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. VBA User Form - Linking Close Button and Cancel Button
    By nivassrii in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2011, 07:05 AM
  2. Cancel Button
    By machado in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-20-2010, 07:46 PM
  3. Cancel Button...
    By NewExcelUser in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2006, 12:59 PM
  4. vb cancel button
    By kckar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2006, 09:45 AM
  5. Cancel button to cancel the whole macro
    By excelnut1954 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-17-2006, 04:30 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