By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,369 Members | 966 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,369 IT Pros & Developers. It's quick & easy.

Populating ListBox in excel with visible cells in filtered Range

P: 1
Excel Gurus,

I am suffering with a problem with the following Code

Expand|Select|Wrap|Line Numbers
  1.  
  2. Me.ListBox1.List = Range("a1:f10").Cells.SpecialCells_(xlCellTypeVisible).VALUE
  3.  
The listbox will popoulate however as soon as the range is autofiltered, only the first line of the autofiltered data will be displayed rather than the entire autofilter range.

Any help will be appreciated!
Feb 4 '08 #1
Share this Question
Share on Google+
1 Reply


QVeen72
Expert 100+
P: 1,445
Hi,

In VB6, I'am not sure, you can give List of items by just setting the "List" Property.
What you can do, is Set the Range Filter Filter Results , to Some TempRange..
and Loop through and Populate the Listbox (using List1.AddItem)..

Regards
Veena
Feb 4 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.