RicardoHorta.Net - www.ricardo.horta.nom.br - Tutorial Excel XP
Parceria RicardoHorta.Net + SUBMARINO !!
Objeto FileDialog: Propriedades
Objeto Font: Propriedades
Parceria RicardoHorta.Net + SUBMARINO !
Excel XP: Eventos
Parceria RicardoHorta.Net + SUBMARINO !
Excel XP: Métodos
-
Métodos ( Visão Geral )
Activate ( Chart, ChartObject, OLEFormat, OLEObject, Pane, Range, Window, Workbook e Worksheet )
Add ( Coleção ChartObjects )
AddCallout ( Coleção Shapes )
AddPicture ( Coleção Shapes )
AddTextbox ( Coleção Shapes )
Apply ( Objeto Shape / Coleção ShapeRange )
ChartWizard ( Objeto Chart )
Delete
Objetos: AllowEditRange, Axis, AxisTitle, CalculatedMember, Characters,
Chart, ChartObject, Objeto da coleção ChartObjects, ChartTitle, Comment, CubeField,
CustomProperty, CustomView, DataLabel, objeto da coleção DataLabels, DataTable,
DiagramNode, DisplayUnitLabel, DownBars, DropLines, ErrorBars, FormatCondition,
objeto da coleção FormatConditions, Gridlines, HPageBreak, HiLoLines, Hyperlink,
LeaderLines, Legend, LegendEntry, LegendKey, Name, OLEObject, objetos da coleção
OLEObjects, objeto da coleção Parameters, objeto da coleção Phonetics, PivotField,
PivotFormula, PivotItem, Point, PublishObject, objeto da coleção PublishObjects,
QueryTable, RecentFile, Scenario, Series, SeriesLines, Shape, objeto da coleção
ShapeNodes, objeto da coleção Sheets, SmartTag, SoundNote, Style, TickLabels,
Trendline, UpBars, UserAccess, VPageBreak, Validation, Watch, Worksheet.
Coleções: Charts, Hyperlinks, Range, ShapeRange, Watches, Worksheets.
Execute ( Objetos CommandBarButton, CommandBarComboBox, CommandBarControl, CommandBarPopup,
FileDialog e FileSearch )
PickUp ( Objeto Shape / Coleção ShapeRange )
Select
Objetos: Axis, AxisTitle, Chart, ChartArea, ChartObject,
objeto da coleção ChartObjects, ChartTitle, Corners, DataLabel,
objeto da coleção DataLabels, DataTable, DisplayUnitLabel, DownBars,
DropLines, ErrorBars, Floor, Gridlines, HiLoLines, LeaderLines,
Legend, LegendEntry, LegendKey, OLEObject, objetos da coleção OLEObjects,
PlotArea, Point, Objeto Series, SeriesLines, Shape, objeto da coleção Sheets,
TickLabels, Trendline, UpBars, Walls e Worksheet
Coleções: Charts, Range, ShapeRange e Worksheets
Show ( Objetos Balloon e FileDialog )
Text ( Comment e WorksheetFunction )
TwoColorGradient ( ChartFillFormat e FillFormat )
UserPicture ( ChartFillFormat e FillFormat )
Parceria RicardoHorta.Net + SUBMARINO !!
Excel XP: Propriedades
-
ActiveMenuBar ( Coleção CommandBars )
Border ( Objetos Axis, AxisTitle, CalloutFormat, ChartArea, ChartObject,
ChartTitle, DataLabel, DataTable, DisplayUnitLabel, DownBars, DropLines,
ErrorBars, Floor, Gridlines, HiLoLines, LeaderLines, Legend, LegendKey,
OLEObject, PlotArea, Point, Series, SeriesLines, Trendline, UpBars,
Walls )
BuiltIn ( Objetos CommandBar, CommandBarButton, CommandBarComboBox,
CommandBarControl, CommandBarPopup, CommandBar, CommandBarControl )
Columns ( Application, Range e Worksheet )
DashStyle ( Objeto LineFormat )
DisableCustomize ( Coleção CommandBars )
DisplayFormulaBar ( Objeto Application )
DisplayFullScreen ( Application )
DisplayHorizontalScrollBar ( Objeto ActiveWindow )
DisplayVerticalScrollBar ( Objeto ActiveWindow )
DisplayScrollBars ( Objeto Application )
DisplayStatusBar ( Objeto Application )
DisplayWorkbookTabs ( Objeto Window )
EntireRow ( Objeto Range )
ForeColor
HasTitle ( Objetos Axis e Chart )
Height
Id ( Objetos CommandBar, CommandBarButton, CommandBarComboBox,
CommandBarControl, CommandBarPopup )
Index ( Objetos CommandBar, CommandBarButton, CommandBarComboBox,
CommandBarControl, CommandBarPopup )
LineStyle ( Objeto Border / Coleção Borders )
Name ( Objetos Assistant, Balloon, BalloonCheckbox, BalloonCheckBoxes,
BalloonLabel, BalloonLabels, CommandBar, DocumentProperty, HTMLProjectItem,
ODSOColumn, PropertyTest, ScopeFolder )
NameLocal ( Objeto CommandBar )
OffSetX ( Objeto ShadowFormat )
OffSetY ( Objeto ShadowFormat )
On
OnAction ( CommandBarButton, CommandBarComboBox, CommandBarControl e CommandBarPopup )
Rotation
RoundedCorners
ScreenUpdating
ScrollColumn ( Objetos Pane e Window ):
01
-
02
-
03
ScrollRow ( Objetos Pane e Window ):
01
-
02
-
03
Shadow:
01
-
02
-
03
Text
Visible:
01
-
02
-
03
-
04
-
05
Visible ( Objeto CommandBar )
Width
Parceria RicardoHorta.Net + SUBMARINO !!
Excel XP: Controles
Excel XP: Controles: Instruções
Excel XP: Controles: Eventos
|
Click ( Controles CheckBox, ComboBox, CommandButton, Frame, Image,
Label, ListBox, MultiPage, OptionButton, TabStrip, ToggleButton )
|
|
Change ( Controles CheckBox, ComboBox, ListBox,
MultiPage, OptionButton, ScrollBar, SpinButton, TabStrip, TextBox e
ToggleButton )
|
|
Enter ( Controles CheckBox, ComboBox, CommandButton, Frame, ListBox,
MultiPage, OptionButton, ScrollBar, SpinButton, TabStrip, TextBox e
ToggleButton )
|
|
Exit ( Controles CheckBox, ComboBox, CommandButton, Frame, ListBox,
MultiPage, OptionButton, ScrollBar, SpinButton, TabStrip, TextBox e
ToggleButton )
|
|
MouseMove ( Controles CheckBox, ComboBox, CommandButton, Frame, Image,
Label, ListBox, MultiPage, OptionButton, TabStrip, TextBox e ToggleButton )
|
|
QueryClose ( Objeto UserForm )
|
Excel XP: Controles: Métodos
Excel XP: Controles: Objetos
Excel XP: Controles: Propriedades
|
Accelerator ( Objetos CheckBox, CommandButton, Label,
OptionButton, ToggleButton, Page e Tab )
|
|
Alignment ( Objetos CheckBox, OptionButton e ToggleButton )
|
|
AutoSize ( Objetos CheckBox, ComboBox, CommandButton, Image, Label,
OptionButton, TextBox e ToggleButton )
|
|
Bold ( Objeto Font )
|
|
BorderColor ( Objetos ComboBox, Frame, Image, Label, ListBox e
TextBox e UserForm )
|
|
BorderStyle ( Objetos ComboBox, Frame, Image, Label, ListBox,
TextBox e UserForm )
|
|
BackColor ( Objetos CheckBox, ComboBox, CommandButton, Frame, Image,
Label, ListBox, MultiPage, OptionButton, ScrollBar, SpinButton, TabStrip,
TextBox, ToggleButton, UserForm )
|
|
BackStyle ( Objetos CheckBox, ComboBox, CommandButton, Image, Label,
OptionButton, TextBox e ToggleButton )
|
|
Cancel ( Objeto CommandButton )
|
|
Caption ( Objetos CheckBox, CommandButton, Frame, Label,
OptionButton e ToggleButton )
|
|
ControlTipText ( Objetos CheckBox, ComboBox, CommandButton, Image, Label, ListBox,
MultiPage, OptionButton, Page, ScrollBar, SpinButton, Tab, TabStrip,
TextBox e ToggleButton )
|
|
Enabled ( Objetos CheckBox, ComboBox, CommandButton, Frame,
Image, Label, ListBox, MultiPage, OptionButton, ScrollBar,
SpinButton, TabStrip, TextBox e ToggleButton )
|
|
ForeColor ( Objeto Font )
|
|
Height( Objetos CheckBox, ComboBox, CommandButton, Image, Label,
ListBox, MultiPage, OptionButton, ScrollBar, SpinButton, TabStrip,
TextBox, ToggleButton )
|
|
Italic ( Objeto Font )
|
|
Left ( Objetos CheckBox, ComboBox, CommandButton, Image, Label,
ListBox, MultiPage, OptionButton, ScrollBar, SpinButton, TabStrip,
TextBox, ToggleButton e UserForm )
|
|
ListWidth ( Objeto ComboBox )
|
|
MaxLength ( Objetos ComboBox e TextBox )
|
|
MousePointer ( Objetos CheckBox, ComboBox, CommandButton, Frame, Image,
Label, ListBox, OptionButton, ScrollBar, SpinButton, TabStrip,
TextBox, ToggleButton, UserForm )
|
|
MultiSelect ( Objeto ListBox )
|
|
Picture ( Objetos CheckBox, CommandButton, Frame, Image, Label,
OptionButton, ToggleButton, Page e UserForm )
|
|
PictureAlignment ( Objetos Frame, Image, Page e UserForm )
|
|
PicturePosition ( Objetos CheckBox, CommandButton, Frame, Image,
Label, OptionButton, ToggleButton, Page e UserForm )
|
|
PictureSizeMode ( Objetos Frame, Image, Page e UserForm )
|
|
RowSource ( Controles ComboBox e ListBox )
|
|
ShowModal ( Objeto UserForm )
|
|
SpecialEffect ( Objetos CheckBox, ComboBox, Frame, Image, Label, ListBox,
OptionButton, TextoBox, ToggleButton e UserForm )
|
|
Style ( Objeto ComboBox, MultiPage e TabStrip )
|
|
TabFixedWidth ( Objetos MultiPage e TabStrip )
|
|
TabIndex ( Objetos CheckBox, ComboBox, CommandButton, Label, ListBox,
MultiPage, OptionButton, ToggleButton, Page, ScrollBar,
SpinButton, TabStrip, TextBox e ToggleButton )
|
|
TabOrientation ( Objetos MultiPage e TabStrip )
|
|
TabStop ( Objetos CheckBox, ComboBox, CommandButton, Label, ListBox,
MultiPage, OptionButton, ToggleButton, Page, ScrollBar,
SpinButton, TabStrip, TextBox e ToggleButton )
|
|
TextAlign ( Objetos ComboBox, Label e TextBox )
|
|
Top ( Objetos CheckBox, ComboBox, CommandButton, Image, Label,
ListBox, MultiPage, OptionButton, ScrollBar, SpinButton, TabStrip,
TextBox, ToggleButton e UserForm )
|
|
Underline ( Objeto Font )
|
|
Value
|
|
Visible ( Objetos CheckBox, ComboBox, CommandButton, Frame, Image, Label, ListBox,
MultiPage, OptionButton, Page, ScrollBar, SpinButton, Tab, TabStrip,
TextBox e ToggleButton )
|
|
Width ( Objetos CheckBox, ComboBox, CommandButton, Image, Label,
ListBox, MultiPage, OptionButton, ScrollBar, SpinButton, TabStrip,
TextBox, ToggleButton e UserForm )
|
SUBMARINO: Fácil ! Rápido ! Seguro !
www.ricardo.horta.nom.br - Direitos adquiridos - Autor: Ricardo Horta - richorta@terra.com.br