Results 1 to 10 of 10

Excel "BeforeDoubleClick" coding advice needed

Threaded View

  1. #1
    Registered User
    Join Date
    11-02-2017
    Location
    CALIFORNIA
    MS-Off Ver
    10
    Posts
    5

    Excel "BeforeDoubleClick" coding advice needed

    Hello! I am new to the forum and am constructing a large multi-sheet workbook for personal use. I and am using simple macros to help with page navigation. On one sheet I want to double click on a single cell in a range of cells and have the corresponding individual macros take me to the corresponding worksheets. I know how to construct simple macros and developed simple code that takes me to a single worksheet but I would like to expand the code statement to take me to different worksheets depending on the cell I double click on. The cells I will click on are are all in one column on one sheet. Thanks in advance for your help.

    Here is what I have that works;

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
        If Selection.Count = 1 Then
            If Not Intersect(Target, Range("B21")) Is Nothing Then
                Call FIDSX
            End If
        End If
    End Sub
    Steve
    Last edited by kayakfisher1; 11-02-2017 at 06:56 PM. Reason: Correcting violation of rule 3

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Stock advisory based on four variables; Urgent, Advice, Not needed and "-"
    By Excell_Ensie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-16-2017, 10:12 AM
  2. [SOLVED] if formula needed to populate either "1" or "0" based on number of units in another cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2015, 11:24 AM
  3. [SOLVED] VBA help needed to remove all "/" then replace with "-" from cell "B3"and "B5"
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2014, 02:11 PM
  4. [SOLVED] Formula Needed to fill multiple cells with "No" when the word "No" is entered into a cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2013, 05:36 PM
  5. [SOLVED] Formula needed to display "Pass" or "Fail" if a column contains any values other than "yes
    By andreindy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2013, 05:49 PM
  6. Help Needed to get Filters Using "Include" and "Exclude" multiple values on one column.
    By alfykunable in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2012, 04:03 AM
  7. Advice needed: "Portable" macros?
    By durex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2005, 07:05 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