98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Custom Autofilter
Custom Autofilter
Resolved · Urgent Priority · Version 2003
Tue 3 Jun 2008, 16:20Delegate Rebecca said...
Rebecca has attended:
Excel Advanced course
Custom Autofilter
How do I write code to implement a custom autofilter to display data that falls between two dates.
I would like to put the code into a user form so the user can select dates they want to show on the report.
Many thanks
Becky
Wed 4 Jun 2008, 09:48Trainer Amanda said...
RE: Custom Autofilter
Hi Rebecca
Thank you for your question.
As resolving your question would require writing a reasonably detailed script, we suggest one of two possible options:
- We can provide training or consulting services to resolve this issue; and any other coding you may want to learn/implement;
- Attend our 2 day Excel VBA course, which includes a section on Working with Forms and Controls amongst other topics.
The course syllabus is available on the following page:
www.stl-training.co.uk/excel-course-in-london-2003-vba.php
If you have any further questions regarding training or consulting services, please call us on phone number; or email info@stl-training.co.uk
Kind regards
Amanda
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Conditional formatting for cells that return text , not picked up by Go to commandIf you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text. |
