Buttons Collection Object

Description

A collection of all the Button objects on the specified chart sheet, dialog sheet, or worksheet.

Accessors

Use the Add method to create a new button and add it to the collection. The following example activates worksheet one and then adds a new button to the active sheet. The new button is positioned over cells C5 and D5.


Worksheets(1).Activate
Set r = ActiveSheet.Range("c5:d5")
Set newButton = ActiveSheet.Buttons.Add(r.Left, r.Top, _
    r.Width, r.Height)

Use the Buttons method with an argument to access a single member of the collection or without an argument to access the entire collection at once.

Properties

Accelerator Property, AddIndent Property, Application Property, AutoSize Property, CancelButton Property, Caption Property, Count Property, Creator Property, DefaultButton Property, DismissButton Property, Enabled Property, Font Property, Formula Property, Height Property, HelpButton Property, HorizontalAlignment Property, Left Property, Locked Property, LockedText Property, OnAction Property, Orientation Property, Parent Property, PhoneticAccelerator Property, Placement Property, PrintObject Property, Text Property, Top Property, VerticalAlignment Property, Visible Property, Width Property, ZOrder Property.

Methods

Add Method (Graphic Objects and Controls), BringToFront Method, Characters Method, CheckSpelling Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Group Method, Item Method, Select Method, SendToBack Method.