Examples of using This code window in English and their translations into Portuguese
{-}
-
Colloquial
-
Official
-
Medicine
-
Financial
-
Ecclesiastic
-
Ecclesiastic
-
Computer
-
Official/political
Then, save and close this code window.
Then save and close this code window, go back to the worksheet, and enter this formula: =getlowerA2.
Then, save and close this code window.
And then save and close this code window, now, if a cell value changes in the third column, a default system beep sound will be played.
Then save and close this code window, now, when the data in range A2.
Then save and close this code window, close and restart the Outlook, now, when you reply or forward an email with category, the category will be kept in the outgoing message in Sent Items, see screenshot.
Then save and close this code window, right click the button, and choose Assign Macro from the context menu, see screenshot.
Then save and close this code window, now, when you click the hyperlink which link to the specific hidden sheet, the hidden sheet will be opened at once.
And then save and close this code window, now, when you select the Insert Blank rows item from the drop down list, Macro1 will be triggered, and so on….
Then save and close this code window, now, when you click different cells, the different values will be displayed into the textbox automatically, see screenshot.
Then save and close this code window, and now, when you change the cell value in the specified range, a message box will pop out to remind you, see screenshot.
Then save and close this code window, now, when you select or click some data cells, the cells will be magnified as a picture automatically, see screenshot.
Then save and close this code window, back to your worksheet, select the chart and right-click, then choose Assign Macro from the context menu, see screenshot.
Then save and close this code window, now, when the value you enter is between 10 and 50 in cell A1, Macro1 will be triggered, if the entered value is greater than 50, Macro2 is executed.
And then save and close this code window, now, when you update or enter new data into the specific worksheet cells, the workbook will be saved automatically without clicking Save button.
Then save and close this code window, go back to the worksheet, now, when you enter data in Column A, the corresponding cell in Column B will enter the current date and time automatically at once.
Then save and close this code window, since then, every time when you launch Outlook, all unread emails which are older than predefined days will be marked as read automatically at once.
Then save and close this code window, now, when you change the values in any cells within the specified range you set in the code, the cells will be tracked, and the workbook is not be shared.
Then save and close this code window, and then click Design Mode to turn off the design mode, now, when selecting one sheet name from the combo box, it will go to that sheet at once, see screenshot.
Then save and close this code window, and go on pressing Alt+ F8 to open the Macro dialog box, click Options button to go to the Macro Options dialog box, and then enter a customized shortcut key you would like, see screenshots.
And then save and close this code window, now, after clicking Print button to print the worksheet or workbook, the specific macro will be executed firstly, after finishing the code, the worksheet or workbook will be printed at once.
Then save and close this code window, now, when you enter the text“True” in cell A1, the current tab color will become green, and when you enter the text“False” in cell A1, the tab color will become red, and if other text is entered into the cell A1, the tab color will become blue automatically.
Then save and close this code window, right click the shape button you have created, choose Assign Macro from the context menu, in the popped out Assign Macro dialog box, click the macro name Openworkbook_Click you have inserted just now, and click OK button, see screenshot.