+ Reply to Thread
Results 1 to 6 of 6

Why macro needs double click to get the actual results ?

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    640

    Why macro needs double click to get the actual results ?

    Dear all, I have a below small macro , it works well , but the problem is , to get the actual output I need to press the macro button in twice , I mean first press it gives partial results & if I press second time then it gives me the actual results why ? , please modify as required..
    Please Login or Register  to view this content.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Why macro needs double click to get the actual results ?

    Hello nur2544,

    There may be several reasons why this code is failing. To get an answer to this problem more quickly, you should post a copy of your workbook.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    640

    Re: Why macro needs double click to get the actual results ?

    Hi Leith Ross, thanks for replay, please check the attachment.
    Attached Files Attached Files

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Why macro needs double click to get the actual results ?

    Hello nur2544,

    Please try the Code as below.

    Please Login or Register  to view this content.
    Also see the "Please consider" note at the bottom of this post.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  5. #5
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    640

    Re: Why macro needs double click to get the actual results ?

    Hi Winon , now it works perfectly, many thanks for your supports..

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Why macro needs double click to get the actual results ?

    Hello nur2544,

    You are welcome.

    Glad that I could help.

    Also, thank you for adding to my Reputation.

+ 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. double click with macro
    By v2k2apj in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-23-2013, 06:17 PM
  2. how to run my macro with double click
    By snapajap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2013, 02:42 PM
  3. [SOLVED] Double-click macro to produce different results based on different cell ranges
    By Hobsons in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-06-2013, 07:28 AM
  4. use of double click to run macro
    By Healthwatch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2009, 08:32 AM
  5. [SOLVED] vlookup: I have to double click each cell to get correct results?
    By gillyd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2006, 09:10 AM

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