Add a list box (Form control)
1. If the Developer tab is not available, display it.
Display the Developer tab
A. Click the Microsoft Office Button, and then click Excel Options.
B. In the Popular category, under Top options for working with Excel, select
the Show Developer tab in the Ribbon check box, and then click OK.
NOTE The Ribbon is a component of the Microsoft Office Fluent user
interface.
2. On the Developer tab, in the Controls group, click Insert, and then under
Form Controls, click List box.


HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Ayo" wrote:

Does anybody knows where I can find help on using Listbox to display results
from a filter operation in Excel 2007. I want to run some filters in excel
and I want to display the results in a control Userform Listbox. And I also
want to be able to format the values in the Listbox.
If anyone can point me to a good source of information on how to accomplish
this, I will be very greatful.
Thanks
Ayo