microsoft excel courses tate - macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses tate - Macros

microsoft excel courses tate - Macros

resolvedResolved · Low Priority · Version Standard

Bobby has attended:
Excel VBA Intro Intermediate course
Excel Advanced course

Macros

What is a class module?

RE: Macros

Hi Bobby

A Class Module is Excel's way of allowing the user to create their own custom objects with custom properties and methods.

It also allows programmers to share pieces of code without needing to understand how it works.

In the VBE the Workbook, Worksheet, Chart and Form modules are all types of enhanced class modules.


Carlos


 

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips


Server loaded in 0.09 secs.