![]() What could you use this tool for? Leave a comment below. This makes the searches extremely fast since the underlying source data is stored in the add-in. I've also developed additional processes to automatically update the GL tables as they are updated in the system. In my application, the tables containing the account codes are stored in the add-in workbook. The user can quickly search for account codes from the GL or database, and quickly insert them into the worksheet. I've used this in an add-in that runs searches on general ledger (GL) account codes. The features and capabilities can be greatly expanded to meet your needs. A sample workbook with all the code is available for free download below. The code uses Chip Pearson's FindAll Function in combination with the KeyUp Event in the text box to return results in the list box as you type. ![]() This is a very basic application that mimics Excel's built-in Find All feature. Find All results in a worksheet or workbook
0 Comments
Leave a Reply. |