Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA

VBA

ResolvedVersion 2003

Thu 11 Jun 2009, 16:30 Delegate Rezaan said...

Rezaan has attended:
Excel VBA Intro Intermediate course

VBA

Are there any pre-existing codes/add-ins which come standard within excel VBA?

Tue 16 Jun 2009, 17:14 Trainer Simon said...

RE: VBA

Hi Rezaan,

Thank you for your question.

I am not aware of any pre-existing code/add-ins that come standard with Excel VBA. When you use the Object Browser to search on Classes, by selecting an event, procedure or method you can get help on it which gives you sample code you can use.

However if you produce a procedure, you can then save it as an add-in and other people can attach that add-in to their Excel application.

I hope this answers your question.

Regards

Simon

Tue 23 Jun 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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

VBA

VBA

RE: VBA

Excel articles

Excel tip:

Sorting List Subtotals