Got any Excel/VBA Questions? Free Excel Help.
Filter ListBox Data
If you have used Excel UserForms before you may have also used the ListBox Control to return a table of data to the user. Sometimes this data is too much information for the user and it needs to be filtered down to meet a specified criteria. With the aid of Excel VBA macro code, Excel's Advanced Filter and a hidden Worksheet we can do this. The Excel Macro code in the attached Workbook consist of one UserForm, some OptionButtons (for and/or type criteria), 2 ListBox controls (1 to show all data, the other to show the resulting filtered data) and some ComboBox controls so we can allow to the user to set multi-layered (compounded) criteria.
|Inputbox in Excel VBA|
|Is Workbook Open/Workbook Exists/Worksheet Exists/Auto Filter/How Many Pages Printed|
|Excel VBA: Create Worksheets for Each Item in an Excel Table of Data|
|Return Last Chosen Day of Given Month|
|Find & Return The Last Used Cell On An Excel Worksheet Or Column|
|Limit Scroll Area on an Excel Worksheet|