Thanks Thanks:  0
Results 1 to 9 of 9

Thread: How to paste picture in messages in Mr Excel.com ?

  1. #1
    Board Regular
    Join Date
    Apr 2019
    Posts
    92
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile How to paste picture in messages in Mr Excel.com ?

    Hi all,

    I'm working on a VBA Code which currently allows to display all items of the Listbox from my Userform, I would like to post a picture to describe what I'm writing, but don't succeed to paste any picture from my laptop. Any ideas ?

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    48,938
    Post Thanks / Like
    Mentioned
    45 Post(s)
    Tagged
    9 Thread(s)

    Default Re: How to paste picture in messages in Mr Excel.com ?

    Welcome to the Board!

    There are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
    Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,195
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    7 Thread(s)

    Default Re: How to paste picture in messages in Mr Excel.com ?

    I prefer seeing written detailed explanation of what your wanting to do.
    I never click on file links on this Forum.
    And pictures sometimes with limited details does not help me much.
    But that's just me.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  4. #4
    Board Regular
    Join Date
    Apr 2019
    Posts
    92
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to paste picture in messages in Mr Excel.com ?

    Hi thanks for your answer, I've checked what type of tool in this website I could use to put screenshot of my Listbox, but none of them seem working. Not grave I'm going to try to explain what I want to do the easiest and clearest way possible

  5. #5
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,195
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    7 Thread(s)

    Default Re: How to paste picture in messages in Mr Excel.com ?

    Well I still have not seen a explanation of what you want.
    You said:
    allows to display all items of the Listbox from my Userform

    Display all the values from your UserForm Listbox?

    Display the values where.

    Your question seems very simple not sure why you think you need to display a image.

    Can you not explain this in 25 words or less?
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  6. #6
    Board Regular
    Join Date
    Apr 2019
    Posts
    92
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to paste picture in messages in Mr Excel.com ?

    Hi, actually I had began an other thread, but here is my problem:

    I try to design an automate structure/organizationnal chart and I'm just at the Beginning of my project

    First, Here is the code of the List Box


    Private Sub CommandButton4_Click()

    Dim I As Long

    For I = 0 To ListBox1.ListCount - 1

    Cells(5, I + 3) = ListBox1.List(I)

    end sub

    All the items of the listbox are displayed in the same row in different columns, like that :
    Item A (one column) Item B (one column) Item C (one column) etc.

    but what I would like is to have is all the items displayed like that ;
    item A in a merged cell (2 colums), Empty column, item B in a merged cell (2 colums), Empty column, item C in a merged cell (2 colums), etc.

    Any ideas ?

  7. #7
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    48,938
    Post Thanks / Like
    Mentioned
    45 Post(s)
    Tagged
    9 Thread(s)

    Default Re: How to paste picture in messages in Mr Excel.com ?

    Hi, actually I had began an other thread, but here is my problem:
    Yes, you will want to post this in the "Excel Questions" forum, and not in this thread in the "About This Board" forum here.
    But I am not seeing any threads (other than this one) started by you on this forum.
    Are you sure you posted it on our Board? Or did you post it in a different Excel help site?
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  8. #8
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,195
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    7 Thread(s)

    Default Re: How to paste picture in messages in Mr Excel.com ?

    I'm not able to help you since I now see you are using merged cells. If you have been on this Forum long you would have seen most everyone discourages using merged cells especially when using them in conjunction with Vba.

    And it appears as if your saying you have posted this same question in another thread.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  9. #9
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    48,938
    Post Thanks / Like
    Mentioned
    45 Post(s)
    Tagged
    9 Thread(s)

    Default Re: How to paste picture in messages in Mr Excel.com ?

    If you have been on this Forum long you would have seen most everyone discourages using merged cells especially
    I think you can clearly see that they just joined this month.

    And it appears as if your saying you have posted this same question in another thread.
    Yes, I told him to above, as these type of questions belong in the "Excel Questions" forum, and not in the "About This Board" forum. I deleted your response to the other thread. Please do not reply to it if you do not have anything helpful to add to it.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •