Rx_
Nothing In Moderation
- Local time
- Yesterday, 23:05
- Joined
- Oct 22, 2009
- Messages
- 2,803
Started a post in Excel, but it might be more of a VBA question.
Created a VBA function that creates a custom busines-rule sort of Customer Name. It works in Access queries and associated forms and list boxes.
When using a CopyFromRecordset to Excel - and setting the header row to Autofilter - there is an A-Z sort. But, that won't re-sort the data using my custom VBA function.
It appears that Excel 2007 object model allows for a custom filter to be created from a function (see below). Does anyone have any pointers on if a custom "sort" can be added to the AutoFilter menu?
http://www.timeatlas.com/5_Minute_Ti...ter_Selections
This is an interesting article on how to build custom AutoFilters using VBA custom functions.
Now, my problem is creating a Custom Sort based on the AutoFilter.
Instead of sorting from A-Z - sort based on a custom function.
Created a VBA function that creates a custom busines-rule sort of Customer Name. It works in Access queries and associated forms and list boxes.
When using a CopyFromRecordset to Excel - and setting the header row to Autofilter - there is an A-Z sort. But, that won't re-sort the data using my custom VBA function.
It appears that Excel 2007 object model allows for a custom filter to be created from a function (see below). Does anyone have any pointers on if a custom "sort" can be added to the AutoFilter menu?
http://www.timeatlas.com/5_Minute_Ti...ter_Selections
This is an interesting article on how to build custom AutoFilters using VBA custom functions.
Now, my problem is creating a Custom Sort based on the AutoFilter.
Instead of sorting from A-Z - sort based on a custom function.
