Vba And Excel Object Model Quick Reference

EXCEL BUILT-IN MENUS AND TOOLBARS

Excel CommandBars

CONSTANT

NAME

TYPE

Worksheet Menu Bar

Menu Bar

2

Chart Menu Bar

Menu Bar

3

Standard

Toolbar

4

Formatting

Toolbar

5

PivotTable

Toolbar

6

Chart

Toolbar

7

Reviewing

Toolbar

8

Forms

Toolbar

9

Stop Recording

Toolbar

10

External Data

Toolbar

11

Formula Auditing

Toolbar

12

Full Screen

Toolbar

13

Circular Reference

Toolbar

14

Visual Basic

Toolbar

15

Web

Toolbar

16

Control Toolbox

Toolbar

17

Exit Design Mode

Toolbar

18

Refresh

Toolbar

19

Watch Window

Toolbar

20

PivotTable Field List

Toolbar

21

Borders

Toolbar

22

Protection

Toolbar

23

Text To Speech

Toolbar

24

Drawing

Toolbar

25

Query and Pivot

Shortcut Menu

26

PivotChart Menu

Shortcut Menu

27

Workbook tabs

Shortcut Menu

28

Cell

Shortcut Menu

VBA QUICK REFERENCE

EXCEL BUILT-IN MENUS AND TOOLBARS (CONTINUED)

Excel CommandBars (Continued)

CONSTANT

NAME

TYPE

29

Column

Shortcut Menu

30

Row

Shortcut Menu

31

Cell

Shortcut Menu

32

Column

Shortcut Menu

33

Row

Shortcut Menu

34

Ply

Shortcut Menu

35

XLM Cell

Shortcut Menu

36

Document

Shortcut Menu

37

Desktop

Shortcut Menu

38

Nondefault Drag and Drop

Shortcut Menu

39

AutoFill

Shortcut Menu

40

Button

Shortcut Menu

41

Dialog

Shortcut Menu

42

Series

Shortcut Menu

43

Plot Area

Shortcut Menu

44

Floor and Walls

Shortcut Menu

45

Trendline

Shortcut Menu

46

Chart

Shortcut Menu

47

Format Data Series

Shortcut Menu

48

Format Axis

Shortcut Menu

49

Format Legend Entry

Shortcut Menu

50

Formula Bar

Shortcut Menu

51

PivotTable Context Menu

Shortcut Menu

52

Query

Shortcut Menu

53

Query Layout

Shortcut Menu

54

AutoCalculate

Shortcut Menu

55

Object/Plot

Shortcut Menu

56

Title Bar (Charting)

Shortcut Menu

57

Layout

Shortcut Menu

58

Pivot Chart Popup

Shortcut Menu

59

Phonetic Information

Shortcut Menu

60

Auto Sum

Shortcut Menu

61

Paste Special Dropdown

Shortcut Menu

+1 0

Post a comment