+ Reply to Thread
Results 1 to 4 of 4

Comment the codes - Sub Get_Shapes_Info?

  1. #1
    Registered User
    Join Date
    12-05-2019
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    88

    Comment the codes - Sub Get_Shapes_Info?

    Dear Expert,

    Could someone explain the vba codes as below:-
    What does it do with the get shapes?

    Attachment included.

    Please Login or Register  to view this content.
    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: Comment the codes - Sub Get_Shapes_Info?

    Please Login or Register  to view this content.
    It seems that a better variant to collect names/descriptions of shapes would be to use an array variable, e.g.:
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Comment the codes - Sub Get_Shapes_Info?

    A little bit late to the party. @porucha vevrku interpretation is spot on.

    I hope this may add something:
    Please Login or Register  to view this content.
    Lewis

  4. #4
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: Comment the codes - Sub Get_Shapes_Info?

    Quote Originally Posted by fgfgicare View Post
    ... Could someone explain ...
    In addition to:
    Quote Originally Posted by LJMetzger View Post
    ... I hope this may add something ...
    As with any matter, this topic should also be considered from various points of view.
    As you can see from the description of LJMetzger this (his) description is fuller and seems to be more understandable than mine ... I turned out to be too lazy ...
    Last edited by mjr veverka; 08-06-2020 at 05:23 PM.

+ 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. [SOLVED] Function to return comment from a cell, or null string if no comment
    By Monkihunta in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2017, 01:01 PM
  2. Replies: 7
    Last Post: 08-13-2015, 10:58 AM
  3. Check if cell in range is empty, if it is delete comment else format comment to
    By banaanas in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2015, 01:15 AM
  4. Copy contents of multiple comment boxes and paste in a single comment box
    By xxJaRxx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-14-2014, 12:39 PM
  5. Disable Delete Comment, Edit Comment, Show/Hide Comment
    By Shanthan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2013, 06:12 AM
  6. Replies: 0
    Last Post: 09-04-2008, 01:35 PM
  7. What are the character codes of a carriage return entered in a comment?
    By John Wirt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-03-2005, 04:01 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