hI
i need some help
in the worksheet i have an auto filter working i filter the data according to the data in column "a" is it possible to build a combo box to control the filter .
hI
i need some help
in the worksheet i have an auto filter working i filter the data according to the data in column "a" is it possible to build a combo box to control the filter .
See http://www.contextures.com/excelfilesRoger.html and scroll down to FastFilter
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
hi
i saw but it not what i need what said i need a combo box to be connected to to column "A" and the filter will work by selecting the data from a combo box
i can not attach any samples because i do not know how to do this
Click on Go Advanced | Manage Attachments and upload the file, or image.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
I have been to the site reccomended by XLD and believe that you can filter quite easily using this method. Do you require the listbox because the user will not remember what to search for?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link