+ Reply to Thread
Results 1 to 7 of 7

Copy contents of multiple comment boxes and paste in a single comment box

  1. #1
    Registered User
    Join Date
    03-13-2014
    Location
    Warwickshire
    MS-Off Ver
    Excel Professional Plus 2010
    Posts
    3

    Question Copy contents of multiple comment boxes and paste in a single comment box

    Hello,

    I am trying figure out how to copy the contents of multiple comment boxes and paste in a single comment box.

    The big picture is that I have a number of cells with numerical values in and text in comment boxes. I want to be able to click a button to copy the contents of the comment boxes and paste them, along with the numerical value from the cell, into a single comment box, ordered by highest to lowest value within the comment box, then delete the original cells and comments.

    Can anyone help? I am quite new to VBA but have been coping quite well so far with information of the web and analysing recorded macros.

    Thanks,
    James

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Copy contents of multiple comment boxes and paste in a single comment box

    can you attach a sample file with data and desired result ?
    If solved remember to mark Thread as solved

  3. #3
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Re: Copy contents of multiple comment boxes and paste in a single comment box

    Please Login or Register  to view this content.
    This will concatenate the cell values of the 3 cells in row A into B4 with a gap between each value (if you want rid of the gap lose the " " & (leave one &.

    I don't know how you would filter by numerical value though. If cell 1 would always be higher than cell 2 and so on then place the cell values in order of numerical value.

  4. #4
    Registered User
    Join Date
    03-13-2014
    Location
    Warwickshire
    MS-Off Ver
    Excel Professional Plus 2010
    Posts
    3

    Re: Copy contents of multiple comment boxes and paste in a single comment box

    Quote Originally Posted by patel45 View Post
    can you attach a sample file with data and desired result ?
    Attached (hopefully)

    Quote Originally Posted by Sc0tt1e View Post
    Please Login or Register  to view this content.
    This will concatenate the cell values of the 3 cells in row A into B4 with a gap between each value (if you want rid of the gap lose the " " & (leave one &.

    I don't know how you would filter by numerical value though. If cell 1 would always be higher than cell 2 and so on then place the cell values in order of numerical value.
    Thanks, but this didn't really do what I was after. Hopefully the attachment will make it clearer
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Copy contents of multiple comment boxes and paste in a single comment box

    with no sorting
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    03-13-2014
    Location
    Warwickshire
    MS-Off Ver
    Excel Professional Plus 2010
    Posts
    3

    Re: Copy contents of multiple comment boxes and paste in a single comment box

    Quote Originally Posted by patel45 View Post
    with no sorting
    Please Login or Register  to view this content.
    Wow, nice one! Thank you! Could you please explain how the code works/comment the code? I am very new to this, so as simple/detailed as possible would be appreciated

  7. #7
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Copy contents of multiple comment boxes and paste in a single comment box

    run the code step by step with F8 and put the mouse pointer over the variables to see the values

+ 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. 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
  2. Insert Contents of a Cell Range into a single Excel Comment
    By ChinaReg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2009, 02:36 AM
  3. How do you add multiple comment boxes?
    By slipit1 in forum Excel General
    Replies: 12
    Last Post: 09-27-2007, 09:26 AM
  4. Macro to create a comment with contents from Paste
    By Steve Walton in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-08-2006, 10:00 AM
  5. [SOLVED] copy and paste graphics into comment boxes
    By steve in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2005, 11: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