+ Reply to Thread
Results 1 to 2 of 2

displaying comments at a certain place

  1. #1
    Forum Contributor
    Join Date
    04-29-2012
    Location
    nuneaton, England
    MS-Off Ver
    Office 365
    Posts
    372

    displaying comments at a certain place

    PHP Code: 
    Range("V11:V702").ClearComments
          
    Dim LR 
    As Long
    LR 
    Range("U" Rows.Count).End(xlUp).Row
    For 10 To LR
       Range
    ("V" i).NoteText Text:=Range("U" i).Value
    Next i


       Dim WS 
    As Worksheet
        
    For Each WS In ActiveWorkbook.Worksheets
    Dim MyComments 
    As Comment
            
    For Each MyComments In ActiveSheet.Comments
                With MyComments
                
    .Shape.TextFrame.AutoSize True
                
    If .Shape.Width 300 Then
                    Dim lArea 
    As Long
                    lArea 
    = .Shape.Width * .Shape.Height
                    
    .Shape.Width 200
                    
    .Shape.Height = (lArea 200) * 1.9
                    End 
    If
                    
    End With
                Next MyComments
            Next WS 
    This code works perfectly for me, but can someone help me modify it so the comment from each cell displays to the left of the cell or at a specific X,Y coordinates. the reason why i ask this is that i have frozen the cells and the comment appears to the right of the frozen part and therefore not in view... i would prefer a certain X,Y coordinates if this is possible

  2. #2
    Forum Contributor
    Join Date
    04-29-2012
    Location
    nuneaton, England
    MS-Off Ver
    Office 365
    Posts
    372

    Re: displaying comments at a certain place

    I have found this

    PHP Code: 
                .Shape.Top = .Parent.Top 50
                
    .Shape.Left = .Parent.Offset(, 1).Left 800 
    but ot wont work if i add it to the rest of the code

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Deciding on 1st place 2nd place etc for a TOP 10 List
    By Brentsa in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-09-2014, 09:54 PM
  2. Replies: 1
    Last Post: 01-03-2012, 08:38 PM
  3. Replies: 3
    Last Post: 08-14-2009, 07:22 AM
  4. Replies: 2
    Last Post: 06-24-2007, 10:16 AM
  5. Big sheet..neeed to jump from place to place
    By RHagerty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2007, 07:48 AM
  6. Auto displaying comments of protected cell
    By vbace2 in forum Excel General
    Replies: 7
    Last Post: 11-06-2006, 04:02 AM
  7. [SOLVED] Displaying cell comments.
    By Dan N in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2006, 03:50 PM
  8. [SOLVED] Cell Comments-Is possible to search for data in comments?
    By dmm129 in forum Excel General
    Replies: 3
    Last Post: 10-28-2005, 03:05 PM

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