Results 1 to 2 of 2

Thread: Can a User Defined Function in a cell be executed by a click on that cell?

  1. #1

    Question Can a User Defined Function in a cell be executed by a click on that cell?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Folks,

    I am the newest of newbies working with VBA programming and Excel.

    I have a matrix of cells, each of which is filled with variations of this:

    =OpenPDF("C:\Users\Mike-K6MKF\Desktop\...\01-Mar-2015_14-55-47_UTC_80.pdf",12,,"none",1,0,0,0,0)

    I found the OpenPDF UDF on the web to allow me to open a specific page in a .pdf file, and it's working just the way I want it to. The example above will allow me to open page 12 of this .pdf file.

    In order for each cell to perform the OpenPDF function, I must now click on the cell, click the cursor into the edit field, the click the 'check' mark and the OpenPDF will open up the correct page for me.

    What I'm looking for is a way, either in this workbook, or another workbook, to 'execute' the contents of a given cell when clicked, without the machinations of a 'fake edit'.

    Any and all suggestions will be greatly appreciated!!

    Thanks!

  2. #2
    Or am I going about this the wrong way?

    Here's my matrix. Each cell contains the function call shown above, to display a specific page in a specific document:

    Click image for larger version. 

Name:	func matrix.JPG 
Views:	4 
Size:	56.7 KB 
ID:	3246

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •