Multiline Combobox

[suoirotciv]

Is there a way that i can view with combobox, my data that is multiline? I mean like in excel that has the property or option to automatically wrap the cell. If this thing is not possible with Combobox, is it possible to Listbox? Please pardon the grammar.
Not good in english.

 

[Jekteir]

You could always just run through the text using the "instr()" function checking where the next vbCRLF came. Every time you find one, reset the current "start position" to just after it, take that text (by using left() and right() with the position of the new vbCRLF and the position of the last one to get just that text), and insert it into a ListBox using AddItem(). Of course, that isn't as simple as finding some builtin function, but as long as you can get the text from the original source, it oughta work. This is providing all the text you want comes from one cell/source/whatever. If you are talking about taking from different cells, well, I know nothing about Excel code.

Jek

 

[zemp]

To add to what Jekteir was saying, you could use the split function to split a multiline string on the vbcrlf character. Your result would be an array that could easily be added to a combo or list box via the .additem method. Thanks and Good Luck!

zemp

 

[suoirotciv]

Jek and Zemp . . . thanks for the idea . . . but i already done that actually that is by default . . . but my user want the way i ask it, she want to view it the way she type it . . . this is just if this thing is possible or not . . .

again tnx Please pardon the grammar.
Not good in english.