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

Doflamingo

Board Regular
Joined
Apr 16, 2019
Messages
238
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 :confused:from my laptop. Any ideas ?
 

Some videos you may like

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,101
Office Version
365
Platform
Windows
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.
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,743
Office Version
2013
Platform
Windows
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.
 

Doflamingo

Board Regular
Joined
Apr 16, 2019
Messages
238
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
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,743
Office Version
2013
Platform
Windows
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?
 

Doflamingo

Board Regular
Joined
Apr 16, 2019
Messages
238
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 ? :confused:
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,101
Office Version
365
Platform
Windows
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?
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,743
Office Version
2013
Platform
Windows
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.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,101
Office Version
365
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,096,358
Messages
5,449,972
Members
405,580
Latest member
MRJT

This Week's Hot Topics

Top