Excel VBA语句集(二)（国外英文资料）.docVIP

Excel VBA语句集(二)（国外英文资料） Excel VBA statement set (2) on Tuesday, April 21, 2009, from the Meteors Blog (150) .parent returns the work book name of the call function (151) application.statusbar = please wait... Write the text to the status column application.statusbar = please wait... The % Completed update status bar text, the percentage application.statusbar = False, which is Completed by the variable Percent delegate, resets the status bar to normal (152) Application. Goto the Reference: = Range ( A1: D4 ) designated cell A1 to D4, equivalent to choose edit - positioning, specify the cell area of A1 to D4, wont appear localization dialog box (153) application.dialogs (xlDialogFormulaGoto). Show Show the location dialog, but the location condition button is invalid (154) application.dialogs (xlDialogSelectSpecial).show Show the location condition dialog (155) Application. The Dialogs (xlDialogFormatNumber.) the show show cell format digital TAB of the Application. The Dialogs (xlDialogAlignment.) the show display format cell the alignment TAB of the Application. The Dialogs (xlDialogFontProperties.) the show display format cell in the font option card Application. The Dialogs (xlDialogBorder.) the show display format cell in the border TAB Application. The Dialogs (xlDialogPatterns.) the show display format cell in the design TAB Application. The Dialogs (xlDialogCellProtection.) the show show protection of the cell format TAB note: can display with a single TAB of the cell format dialog box, display a TAB for only one time. (156) Application. Dialogs (xlDialogFormulaGoto) show the Range ( b2 ), a True show reference default cell area and displays a reference to make it appear in the left upper corner of the window (note: the use of built-in dialog parameters) (157) Application.Com mandBars (1).controls (2).controls (16).execute Execute the locate message box, which corresponds to the menu edit - locate command (158) Application. (Array ( Sun , Mon, Tur, ), ) )