training in excel - Excel VBA

Resolved · Low Priority · Version Standard

Excel VBA

Ben has attended:
Access Introduction course
Access Intermediate course

by - delegate Ben [4 posts] (2007 Dec 20 Thu, 16:37) Reply

Can you explain more complex user defined functions?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 5 Fri	Bayswater	0	FULL
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	4	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	1	book now	£235	£240
Full Schedule: See all 95 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel VBA

by - trainer Stephen gold contributer [386 posts] (2008 Jan 4 Fri, 11:15) Reply

Hi ben

Thank you for your question

User defined functions can be written to address a huge range of different tasks. To address your question we need to narrow things down a bit.
Could you give me some idea of the sort of things that you are trying to accomplish?

Thanks

Stephen

· Microsoft Excel Training: Not Just for Newbies Anymore
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· MS Excel: Excel At Making The Most Of Your Christmas
· How to Create Better Excel Spreadsheets: Part One
· Identifying Suitable Candidates For VBA For Excel Training

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Rate this page: