Examples of using Save the code in English and their translations into German
{-}
-
Colloquial
-
Official
-
Ecclesiastic
-
Medicine
-
Financial
-
Ecclesiastic
-
Political
-
Computer
-
Programming
-
Official/political
-
Political
Click OK and save the code.
Then save the code and go back to worksheet.
Click the Download button to save the code you have written.
Save the code and close the Microsoft Visual Basic for Applications window.
Allows to correctly save the code to save the record.
Then save the code, and restart the Outlook to take the code effect.
After pasting the code, then save the code and close the window.
Then save the code and go back to Outlook, under Home tab, click Rules> Manage Rules& Alerts.
In the Module script, paste below code to it, and then save the code and close the VBA window.
You can view, change, and save the code using its IDE Environment window and editor tabs.
Save the code, and now when you select a range,the range's border color will be change to red.
Save the code and go back to the sheet, while clicking on the cell C1 which contains data validation list.
Then save the code and close the Module window, and then select a cell that output result, and type this formula =COUNTVISIBLEB3.
Save the code and go back to the workbook, while you modified the sheet, the cells will be highlighted with a background color.
Then save the code and go back to the sheet,the cell value will be added to the comment while clicking the cell.
Save the code and press F5 key to run the code, and a dialog will pop to remind you that the sheet is empty or not.
Save the code and go back to reply or forward an email,the prefixes are still in the subject, but it will be removed after sending the email.
Save the code and close the Applications window, select a blank cell and enter this formula=AddSpaces(A1), then drag autofill handle over cells you want to apply this formula.
Save the code and close the window, select a blank cell to type this formula=GetURL(A2)(A2 is the cell that the hyperlink in), and press Enter button.
Save the code and close the window, select a blank cell and type this formula GetBold(A2), then press Enter button, and drag the fill handle to fill the range you want.
Save the code and close the window, and type this formula=Addth(C2) into a blank cell(cell C2 is the cell that you want to convert to ordinal number), then press Enter key.
Then save the code and close this code, now, when you double click a cell once, a cross mark is inserted, and when double clicking a second time, a tick mark is displayed, see screenshot.
Save the code and go back to the sheet you want to extract comment contents, type=getComment(B2) in a cell which will place the comment content at, and press Enter key.
Then save the code, in this example, I will get the third word from the string, so type this formula=findword(A2,3) into a blank cell B2, and then drag this cell's AutoFill handle to the range as you need.
Save the code and close the window to go back your worksheet, and type this formula=RandomizeDates(2014) into a cell, then press Enter key and drag the fill handle to a range you need.
Then save the code and close the Module window, and go back to the worksheet, enter this formula=HasComment(B2) into a blank cell next to the comment cell,(B2 contains the value that you want to use) see screenshot.
Save the code and close the window, then type this formula=SumColumn(A1)(A1 is the first cell in the list column) into the first cell of list column, press Enter button, then the list except the header is summed up.
Save the code and close the window, then type this formula=TextOnly(A1)(A1 is the first row cell in your list range you want to extract text only from) into a blank cell, press Enter button, then fill the handle to the range you want.
Save the code and close the window, select a blank cell, for instance, the Cell A1, enter this formula=ConvertDecimal("10° 27' 36""")("10° 27' 36""" stands the degree you want to convert to decimal degree, you can change it as you need), then click Enter button.