| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help using ListBox in VBA
Thanks, this is very helpful.
"JLGWhiz" wrote: I don't know of a place where you can get all of the possible variations of using filtered data to populate a list box. You could use the visible cells to create an array from which you could use the add item method or the list method to populate the control. You can also copy the filtered range to a permanent range in the worksheet and use the ListFillRange or RowSource property to populate the control. Then the control must be defined as single or multi column and as single or multi-select. And a couple of other options. I would suggest that you use the VBA help files to start with and try to develop a procedure from the information you get from those tools. When you get something put together, post back, for help from the newsgroup and post what you have tried with an explanation of what your goal is. Someone here will help you along. "Ayo" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
| avoiding duplicates in listbox (added from another listbox) | Excel Programming | |||
| VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Threaded Mode
