vba courses london - Excel VBA

Resolved · Low Priority · Version Standard

Fri 16 Mar 2007, 16:20 Delegate Chris said...

Chris has attended:
Excel VBA Intro Intermediate course

Excel VBA

How can I redesign a command button?

Tue 20 Mar 2007, 11:16 Trainer Carlos said...

RE: Excel VBA

Once you place a command button on a form you can change its properties. To do this:

Right click the button
Select Properties

In the Properties window change the values of the Back colour, Font and Style of the button to your desired look

VBA tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips

vba courses london - Excel VBA

Excel VBA

RE: Excel VBA

VBA articles

VBA tip:

Count the Rows and Columns in a Selection