Create ListBox (?) same as Find all Result List

[Soniya]

Hi All,

How Can I make a control similar to Find all List in
Excel Find and Replace results.

With My own Heading and able to increase / decrease
column width same as Find all Results.

What i am doing is to get a list from my database based
on textbox1.text

i should have a heading with name, amount, recno, remarks
and data listed below. i have the code to get this result
in a listbox without heading and column seperation.

TIA
Soniya

 

[Tom Ogilvy]

You can not have column headings in a listbox unless you use the rowsource
property. You would need to write your found data to a temporary area on a
worksheet and assign the rowsource property to it.