#1
|
|||
|
|||
Filter in Userform
Hi there, was wondering if anyone would be able to help? I have a spreadsheet which I would like, when opened, to display a userform (this bit I have sussed). Within this userform, I would like a list box, or something similar to the drop-down autofilter list which would allow the user to filter a column (in this case column E) rather than do it within the spreadsheet. Any idea if this is doable and if so, how? Many thanks |
#2
|
|||
|
|||
You won't be able to get filter arrows on a listbox to use for filtering but you can add a textbox to the form and have the listbox filter as you type in the textbox.
http://elcha-en.blogspot.ca/2016/09/...ox-values.html |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filter Mail Merge based on a list of filter criteria | AusSteelMan | Mail Merge | 2 | 05-09-2016 03:35 PM |
Userform calls other userform, then populate worksheet | Lehoi | Excel Programming | 0 | 02-03-2016 02:58 PM |
VBA Code in a UserForm module to delete a Command Button which opens the userform | Simoninparis | Word VBA | 2 | 09-21-2014 03:50 AM |
Is it possible to take an input from a UserForm in one document to a UserForm in a do | BoringDavid | Word VBA | 5 | 05-09-2014 09:08 AM |
filter | kwlickt | Excel | 1 | 03-28-2011 11:15 AM |