+ Reply to Thread
Results 1 to 2 of 2

VBA to find the value of the clicked cell on an another sheet

  1. #1
    Forum Contributor
    Join Date
    11-25-2018
    Location
    Philippines
    MS-Off Ver
    Ms Office 365
    Posts
    217

    VBA to find the value of the clicked cell on an another sheet

    The sample file has two sheets in it. "Entry" and the "Storage"

    In entry sheet, there are data on column A and B.

    Column A is control no. which will serve as the lookup value but with some conditions that must be met on Column B (Status)
    The find macro or function will be triggered when clicking on any cell in column B at sheet entry"
    If I click the B3 on sheet entry, then it will search the value of Cell A3 at Sheet Storage row 2:2. ONLY if the value of B3 is equal to "Vaulted". So it will take me to sheet storage directly to where is the control number is located (cell G2)
    If cell B3 is not "Vaulted" then a pop up msg will say "Not Vaulted".

    I hope it is possible and someone can help me in this.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: VBA to find the value of the clicked cell on an another sheet

    Hi archvanarl

    Try below code, right click on 'Entry' tab --> view code --> paste below code ... It will work on double click in cell in column B

    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

+ 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. Replies: 5
    Last Post: 01-30-2021, 04:49 PM
  2. [SOLVED] Use Vlookup as macro on clicked cell and all cell values below that clicked cell
    By harman83 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-06-2015, 12:58 PM
  3. Hide Columns in sheet based on value in double clicked cell
    By lassil98 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2014, 01:18 AM
  4. Copy double-clicked cell to next empty row in different sheet with each double-click
    By erhathaway in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-25-2013, 12:06 AM
  5. [SOLVED] Load web image when cell holding URL is clicked/double-clicked
    By jchamber00 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2013, 09:13 PM
  6. [SOLVED] code so that when a cell is clicked, a tick mark goes in the cell that was clicked
    By behnam in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-08-2013, 01:17 PM
  7. Change cell value when right-clicked/double-clicked
    By grime in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-17-2005, 09:05 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