Results 1 to 4 of 4

Create a flyout when cell is clicked

Threaded View

JA1 Create a flyout when cell is... 11-26-2013, 04:45 PM
mehmetcik Re: Create a flyout when cell... 11-26-2013, 05:59 PM
JA1 Re: Create a flyout when cell... 11-26-2013, 07:12 PM
JA1 Re: Create a flyout when cell... 11-26-2013, 07:32 PM
  1. #1
    Registered User
    Join Date
    10-17-2007
    Location
    IRELAND
    Posts
    7

    Create a flyout when cell is clicked

    I think I may be trying to do the impossible here, but...

    What I want to do is be able to click on a cell [Private Sub Worksheet_SelectionChange(ByVal Target As Range)]

    That cell will have a range of cells associated with it, and a flyout will appear (much as the cell Comments flyout) which will contain the range of cells associated with that cell.

    I would also like to know how to add a little "arrow" (as per the cell with Comments) that triggers the flyout.

    I'd like the flyout to be a sort of popup range of cells and look like a range of cells, but if I have to create a comment with the data, then I'll do it that way...

    The example image I've attached sort of shows what I want to do, but I'd prefer it to not looks so much like a comment!

    Thanks.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create button on spreadsheet when clicked record date stamp in the next column
    By HBHB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2013, 06:52 PM
  2. [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
  3. [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
  4. Create cell flyout w/Hyperlinks
    By Designer in forum Excel General
    Replies: 0
    Last Post: 09-23-2008, 09:34 AM
  5. 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

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