Wednesday, February 8, 2012

Excel VBA command (4)

Calculation

Command

Description

Application.Calculation = xlManual

Set calculation option to Manual (by F9)

Application.Calculation = xlAutomatic

Set calculation option to Automatic

Activesheet.Calculate

Calculate on activesheet only

CutCopyMode

Command

Description

Application.CutCopyMode=False

Clear data in clip board

Quit

Command

Description

Application.Quit

Quit Excel

ScreenUpdating

Command

Description

Application.ScreenUpdating = False

Result of commands between both will not display on screen

Application.ScreenUpdating = True

StatusBar

Command

Description

Application.DisplayStatusBar = False

Not display status bar

Application.DisplayStatusBar = True

Display status bar

Application.StatusBar = "Test"

Set to show "Test" on status bar

DisplayAlert

Command

Description

Application.DisplayAlerts = False

Not display any alert such as dialog box

Application.DisplayAlerts = True

Display alert

No comments:

Post a Comment