+ Reply to Thread
Results 1 to 2 of 2

comments mouseover on frozen cells

  1. #1
    Registered User
    Join Date
    02-09-2006
    Posts
    2

    comments mouseover on frozen cells

    Hi all,

    I have attached a comment to a frozen pane, and expecting it to do it's mouse over popup below the "freeze-line", this is however not true, the comment box is fixed to the original cells below the cell i created it on, and therefore the comment disappear when scrolled down. Any way to fix this or pop another floating textbox on mouseover?

    T-Rex

  2. #2
    Registered User
    Join Date
    02-09-2006
    Posts
    2
    got it working myself, code following for others
    Label1 is the clickable area, and label 2 contains the info

    Private Sub Label2_Click()
    If (Label1.Visible = False Or Label1.Top + Label1.Height < ActiveWindow.VisibleRange.Top) Then
    With ActiveWindow.VisibleRange
    Label1.Top = .Top + 5
    Label1.Left = Label2.Left - 120
    Label1.Visible = True
    End With
    Else: Label1.Visible = False
    End If
    End Sub

+ 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