Copying worksheet data to a list box

[datastream]

1st userform is set up to adjust the autofilter in a worksheet, the next button enters these changes and calls up the 2nd userform which should display the new filtered list, BUT the listbox in the 2nd userform keeps displaying the original unfiltered data??? Is there some process in VBA that loads the listbox before performing the filter operations? How can i prevent this from happening and only load the listbox with the filtered data that is working in the worksheet, but not reflected in the listbox... thanks for any help

 

[Ivan F Moala]

On 2002-04-20 12:52, datastream wrote:
1st userform is set up to adjust the autofilter in a worksheet, the next button enters these changes and calls up the 2nd userform which should display the new filtered list, BUT the listbox in the 2nd userform keeps displaying the original unfiltered data??? Is there some process in VBA that loads the listbox before performing the filter operations? How can i prevent this from happening and only load the listbox with the filtered data that is working in the worksheet, but not reflected in the listbox... thanks for any help

If I understand you correctly.
The listbox will only show data that you have
assigned to it weather that is from a
predefined sheet range or an array of values
you have set up. When you have autofiltered the range, the Data in the listbox will still show your entire data
range. To only show the filtered list you
will have to reload this filterd list into
the listbox after it is filtered.

Do a search here for Autofilter show visble

Or repost for help

 

[datastream]

ya, thanks for the advice. one alternative i had was just to copy the results into a new worksheet and have the listbox display off of that sheet. but was trying to avoid the extra work.
john