+ Reply to Thread
Results 1 to 8 of 8

Sub Worksheet_BeforeDoubleClick

  1. #1
    Registered User
    Join Date
    07-27-2012
    Location
    Gallarate, Italy
    MS-Off Ver
    Excel 2010
    Posts
    5

    Sub Worksheet_BeforeDoubleClick

    Please Login or Register  to view this content.
    I have a problem with the above code....so if I click B9 cell ok it bring me the selection that I want, but if I click B10 which is a blank field it bring me the same selection...my question is how to make the code to not bring anything and remain on sheet 1?

    thank you,
    ana
    Last edited by ana.ciofrangeanu; 06-24-2014 at 10:15 AM. Reason: first query on forum

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Sub Worksheet_BeforeDoubleClick

    May be like this.....
    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    07-27-2012
    Location
    Gallarate, Italy
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Sub Worksheet_BeforeDoubleClick

    Hi sktneer,

    You are my hero ...worked just fine.

    Thank you so much.
    Regards,
    Ana

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Sub Worksheet_BeforeDoubleClick

    You're welcome. Thanks for the feedback.
    If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
    Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

  5. #5
    Registered User
    Join Date
    07-27-2012
    Location
    Gallarate, Italy
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Sub Worksheet_BeforeDoubleClick

    Done as suggested!

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Sub Worksheet_BeforeDoubleClick

    One more thing.
    Unknowingly you also violated Forum Rule 3. You didn't use the Code Tags around your code. So in future please take care of it.
    Better if you edit your post#1 even you have marked it Solved.
    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

  7. #7
    Registered User
    Join Date
    07-27-2012
    Location
    Gallarate, Italy
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Sub Worksheet_BeforeDoubleClick

    Sorry for that(this was my very first post)...I've amended as suggested.

  8. #8
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Sub Worksheet_BeforeDoubleClick

    Thanks for everything.

+ 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. Worksheet_BeforeDoubleClick Not Working
    By hydz1213 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2014, 06:50 AM
  2. [SOLVED] Worksheet_BeforeDoubleClick - Time stamp
    By Jack40 in forum Excel General
    Replies: 1
    Last Post: 10-22-2012, 06:41 AM
  3. ambiguous name detected : Worksheet_beforedoubleclick
    By eina28 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-19-2011, 05:04 AM
  4. Can Worksheet_BeforeDoubleClick work over a DropBox?
    By Wizz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-13-2009, 09:29 AM
  5. [SOLVED] Sub Worksheet_BeforeDoubleClick from elsewhere?
    By Jack Sons in forum Excel General
    Replies: 2
    Last Post: 11-02-2005, 06:17 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