+ Reply to Thread
Results 1 to 5 of 5

Using double-click on mouse to perform an action?

  1. #1
    Registered User
    Join Date
    01-17-2006
    Location
    Fresno, CA, USA
    MS-Off Ver
    2016
    Posts
    26

    Question Using double-click on mouse to perform an action?

    Hello! I have an excel file with a column (I) which lists the total number of businesses in a different tab (DATA) that meet certain restrictions (these restrictions being listed in the same row in different cells). When the cell under coluimn "I" is double-clicked, it pulls the businesses from tab DATA that meet the restrictions for that row and shows them all in another tab.

    I don't know the person that created this and was wondering if there is a way to figure out what is being done to make this happen? I looked in macros, but didn't see anything relating to this. Anyone know how this is done?

    So you know, I have tried double-clicking other cells, but nothing happens - not even editing into the cell (altho this can be done from the toolbar up top).
    Last edited by mgarcia; 08-19-2009 at 01:46 AM.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Using double-click on mouse to perform an action?

    My guess is there is a macro in either the worksheet, workbook or code module. This event sounds like it's in the worksheet_BeforeDoubleClick event and set to check if column l is the target of the double-click.

    If you can upload the workbook we can check. You can clear out any private data if necessary.

  3. #3
    Registered User
    Join Date
    01-17-2006
    Location
    Fresno, CA, USA
    MS-Off Ver
    2016
    Posts
    26

    Re: Using double-click on mouse to perform an action?

    I checked where you mentioned and this is what's there....

    Please Login or Register  to view this content.
    I would upload a copy, but it has some sensitive information in the file and there is alot in there - most of the stuff i have to remove is part of what gets sorted also.
    Last edited by Paul; 08-18-2009 at 11:42 PM.

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Using double-click on mouse to perform an action?

    Based on that code (which I've wrapped in CODE tags for you - please remember to do this next time), there is another section of code somewhere in the workbook called "Prep". Possibly "Function Prep" in a module. This other code accepts two arguments (a range and a boolean value). My guess is that this other code checks to see if the Target cell is in column l. (Lower case L? Upper case i? either way, something else is there).

  5. #5
    Registered User
    Join Date
    01-17-2006
    Location
    Fresno, CA, USA
    MS-Off Ver
    2016
    Posts
    26

    Re: Using double-click on mouse to perform an action?

    Awesome... i located it. Thanks alot for your help!

    Mgarcia

    PS: I'll remember those CODE tags next time =)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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