Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create ListBox (?) same as Find all Result List
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create ListBox (?) same as Find all Result List
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. -- Regards, Tom Ogilvy "Soniya" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using LEN / LEFT / MID / FIND functions to create a list | Excel Discussion (Misc queries) | |||
where do i find create list in Excel | Excel Worksheet Functions | |||
Find / compare result with list | Excel Worksheet Functions | |||
how do i create a find function for an excel drop list? | Excel Discussion (Misc queries) | |||
How to create a ListBox with 'hyperlink'-like items in VBA ? | Excel Programming |