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

Doflamingo

Board Regular
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 ?
 

My Aswer Is This

Well-known Member
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
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
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
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
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
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
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.
 

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top