+ Reply to Thread
Results 1 to 3 of 3

Function linked to cells

  1. #1
    Registered User
    Join Date
    08-31-2011
    Location
    Tokyo
    MS-Off Ver
    Excel 2010
    Posts
    50

    Question Function linked to cells

    Hello,

    I wonder if it is possible to launch a function by selecting a cell.
    It may be a very basic question but I have never used a function without using ActiveX controller.

    For more details, I would like to apply it to a specific range of cells.

    Thank you very much
    Last edited by oro77; 02-09-2012 at 09:01 PM. Reason: solved

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Function linked to cells

    Yes, you can use the Selection Change event in VBA to see if the cell selected is the one you want to launch your function.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-31-2011
    Location
    Tokyo
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Function linked to cells

    Sorry for my late reply.

    Thank you very much, it works perfectly !

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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