+ Reply to Thread
Results 1 to 3 of 3

does excel have the capability to react to the simple act of clicking a cell?

  1. #1
    Registered User
    Join Date
    08-25-2007
    Posts
    4

    does excel have the capability to react to the simple act of clicking a cell?

    i have a spreadsheet with 1 column (A) that has the numbers 1-10

    each time i click any of the numbers i would like excel to "react" by adding this occurence to the next cell...

    in other words... if i click this sequence: 2,5,2,5,3,5,6,2,5...
    excel would input each occurence in the adjoining cell:
    1-0
    2-3
    3-1
    4-0
    5-4
    6-1
    7-0
    8-0
    9-0
    10-0

    am i high?
    if this is impossible, is there an application that can do this

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    You can have a macro run when you double click on a cell or when you right click on a cell

    'These instructions pre typed & are worded to cater for the novice programmer
    'To install macro to correct location

    'Copy this macro
    'GoTo Excel
    'Select sheet this is to appy to
    'Right Click on Sheet Name Tab > select View Code
    'Past macro into the Worksheet Module displayed


    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  3. #3
    Registered User
    Join Date
    08-25-2007
    Posts
    4
    wow... unreal

    i feel like i just saw santa claus

    thanks man... works terrific

+ 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