Merge branch 'main' into patch-3

MicrosoftDocs · Dec 30, 2021 · 584d8d7 · 584d8d7
2 parents a842f9c + a5498ed
commit 584d8d7
Show file tree

Hide file tree

Showing 21 changed files with 126 additions and 52 deletions.
diff --git a/Language/Reference/User-Interface-Help/msgbox-function.md b/Language/Reference/User-Interface-Help/msgbox-function.md
@@ -26,7 +26,7 @@ The **MsgBox** function syntax has these [named arguments](../../Glossary/vbe-gl
 |Part|Description|
 |:-----|:-----|
 |_prompt_|Required. [String expression](../../Glossary/vbe-glossary.md#string-expression) displayed as the message in the dialog box. The maximum length of _prompt_ is approximately 1024 characters, depending on the width of the characters used. If _prompt_ consists of more than one line, you can separate the lines by using a carriage return character (**Chr**(13)), a linefeed character (**Chr**(10)), or carriage return - linefeed character combination (**Chr**(13) & **Chr**(10)) between each line.|
-|_buttons_|Optional. [Numeric expression](../../Glossary/vbe-glossary.md#numeric-expression) that is the sum of values specifying the number and type of buttons to display, the icon style to use, the identity of the default button, and the modality of the message box. If omitted, the default value for _buttons_ is 0.|
+|_buttons_|Optional. [Numeric expression](../../Glossary/vbe-glossary.md#numeric-expression) that is the combination of values specifying the number and type of buttons to display, the icon style to use, the identity of the default button, and the modality of the message box. If omitted, the default value for _buttons_ is 0.|
 |_title_|Optional. String expression displayed in the title bar of the dialog box. If you omit _title_, the application name is placed in the title bar.|
 |_helpfile_|Optional. String expression that identifies the Help file to use to provide context-sensitive Help for the dialog box. If _helpfile_ is provided, _context_ must also be provided.|
 |_context_|Optional. Numeric expression that is the Help context number assigned to the appropriate Help topic by the Help author. If _context_ is provided, _helpfile_ must also be provided.|
@@ -60,7 +60,7 @@ The _buttons_ [argument](../../Glossary/vbe-glossary.md#argument) settings are:
 
 <br/>
 
-The first group of values (0-5) describes the number and type of buttons displayed in the dialog box; the second group (16, 32, 48, 64) describes the icon style; the third group (0, 256, 512) determines which button is the default; and the fourth group (0, 4096) determines the modality of the message box. When adding numbers to create a final value for the _buttons_ argument, use only one number from each group.
+The first group of values (0-5) describes the number and type of buttons displayed in the dialog box; the second group (16, 32, 48, 64) describes the icon style; the third group (0, 256, 512) determines which button is the default; and the fourth group (0, 4096) determines the modality of the message box. When combining numbers to create a final value for the _buttons_ argument, use only one number from each group.
 
 > [!NOTE] 
 > These [constants](../../Glossary/vbe-glossary.md#constant) are specified by Visual Basic for Applications. As a result, the names can be used anywhere in your code in place of the actual values.
@@ -95,7 +95,7 @@ This example uses the **MsgBox** function to display a critical-error message in
 ```vb
 Dim Msg, Style, Title, Help, Ctxt, Response, MyString
 Msg = "Do you want to continue ?"    ' Define message.
-Style = vbYesNo + vbCritical + vbDefaultButton2    ' Define buttons.
+Style = vbYesNo Or vbCritical Or vbDefaultButton2    ' Define buttons.
 Title = "MsgBox Demonstration"    ' Define title.
 Help = "DEMO.HLP"    ' Define Help file.
 Ctxt = 1000    ' Define topic context. 

diff --git a/Language/Reference/User-Interface-Help/select-case-statement.md b/Language/Reference/User-Interface-Help/select-case-statement.md
@@ -72,7 +72,7 @@ Case 1 To 5    ' Number between 1 and 5, inclusive.
 Case 6, 7, 8    ' Number between 6 and 8. 
     Debug.Print "Between 6 and 8" 
 Case 9 To 10    ' Number is 9 or 10. 
-Debug.Print "Greater than 8" 
+    Debug.Print "Greater than 8" 
 Case Else    ' Other values. 
     Debug.Print "Not between 1 and 10" 
 End Select

diff --git a/access/Concepts/Miscellaneous/in-operator-microsoft-access-sql.md b/access/Concepts/Miscellaneous/in-operator-microsoft-access-sql.md
@@ -16,8 +16,9 @@ Determines whether the value of an expression is equal to any of several values
 
 ## Syntax
 
-_expr_ [ **Not** ] **In**( _value1, value2, …_ )
+_expr_ [ **Not** ] **In** ( _value1, value2, …_ )
 
+_expr_ [ **Not** ] **In** ( _[SELECT](https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/select-statement-microsoft-access-sql?redirectedfrom=MSDN) …_ )
 
 ## Remarks
 
@@ -38,6 +39,12 @@ FROM Orders
 WHERE ShipRegion In ('Avon','Glos','Som')
 ```
 
+You can also use **In** to reference a table or query that exists in an external database file:
+
+```sql
+SELECT qryValues 
+FROM qryValues In 'c:\files\MyDB.accdb'
+```
 
 ## Example
 
@@ -82,4 +89,4 @@ End Sub
 - [Access developer and VBA programming help center (FMS)](https://www.fmsinc.com/MicrosoftAccess/developer/)
 - [Access posts on StackOverflow](https://stackoverflow.com/questions/tagged/ms-access)
 
-[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
+[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
diff --git a/api/Access.TempVar.md b/api/Access.TempVar.md
@@ -23,7 +23,7 @@ Represents a variable that can be used in Visual Basic for Applications (VBA) co
 
 Although a **TempVar** object can be used to store information for use in VBA procedures, it does not have the same functionality as a VBA variable.
 
-- By default, a **TempVar** object remains in memory until Access is closed. You can use the **[Remove](Access.TempVars.Remove.md)** method or the [RemoveTempVar](overview/Access.md) macro action to remove a **TempVar** object.
+- By default, a **TempVar** object remains in memory until the Database is closed. You can use the **[Remove](Access.TempVars.Remove.md)** method or the [RemoveTempVar](overview/Access.md) macro action to remove a **TempVar** object.
 
 - In VBA, a **TempVar** object is accessible only to the members of the Access **[Application](Access.Application.md)** object, referenced databases, or add-ins.
 

diff --git a/api/Excel.CellFormat.IndentLevel.md b/api/Excel.CellFormat.IndentLevel.md
@@ -14,7 +14,7 @@ ms.localizationpriority: medium
 
 # CellFormat.IndentLevel property (Excel)
 
-Returns or sets a **Variant** value that represents the indent level for the cell or range. Can be an integer from 0 to 15.
+Returns or sets a **Variant** value that represents the indent level for the cell or range. Can be an integer from 0 to 250.
 
 
 ## Syntax
@@ -26,9 +26,9 @@ _expression_ A variable that represents a **[CellFormat](Excel.CellFormat.md)**
 
 ## Remarks
 
-Using this property to set the indent level to a number less than 0 (zero) or greater than 15 causes an error.
+Using this property to set the indent level to a number less than 0 (zero) or greater than 250 causes an error.
 
 
 
 
-[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
+[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
diff --git a/api/Excel.Point.MarkerBackgroundColor.md b/api/Excel.Point.MarkerBackgroundColor.md
@@ -14,7 +14,7 @@ ms.localizationpriority: medium
 
 # Point.MarkerBackgroundColor property (Excel)
 
-Sets the marker background color as an RGB value or returns the corresponding color index value. Applies only to line, scatter, and radar charts. Read/write **Long**.
+Sets the marker background color as an RGB value or returns the corresponding color index value. The background color is displayed as the Fill color in the application. Applies only to line, scatter, and radar charts. Read/write **Long**.
 
 
 ## Syntax
@@ -26,16 +26,24 @@ _expression_ A variable that represents a **[Point](Excel.Point(object).md)** ob
 
 ## Example
 
-This example sets the marker background and foreground colors for the second point in series one on Chart1.
+This example sets the marker background (fill) and foreground (border) colors for the first point in series one on Chart1.
 
 ```vb
-With Charts("Chart1").SeriesCollection(1).Points(2) 
- .MarkerBackgroundColor = RGB(0,255,0) ' green 
- .MarkerForegroundColor = RGB(255,0,0) ' red 
+With Charts("Chart1").SeriesCollection(1).Points(1) 
+ .MarkerBackgroundColor = RGB(0,255,0) ' green fill
+ .MarkerForegroundColor = RGB(255,0,0) ' red border
 End With
 ```
 
+This example sets the marker colors to automatic for the second point in series one on Chart1.
+
+```vb
+With Charts("Chart1").SeriesCollection(1).Points(2) 
+ .MarkerBackgroundColor = -1 ' automatic fill
+ .MarkerForegroundColor = -1 ' automatic border
+End With
+```
 
 
 
-[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
+[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
diff --git a/api/Excel.Point.MarkerForegroundColor.md b/api/Excel.Point.MarkerForegroundColor.md
@@ -14,7 +14,7 @@ ms.localizationpriority: medium
 
 # Point.MarkerForegroundColor property (Excel)
 
-Sets the marker foreground color as an RGB value or returns the corresponding color index value. Applies only to line, scatter, and radar charts. Read/write **Long**.
+Sets the marker foreground color as an RGB value or returns the corresponding color index value. The foreground color is displayed as the Border color in the application. Applies only to line, scatter, and radar charts. Read/write **Long**.
 
 
 ## Syntax
@@ -26,15 +26,24 @@ _expression_ A variable that represents a **[Point](Excel.Point(object).md)** ob
 
 ## Example
 
-This example sets the marker background and foreground colors for the second point in series one on Chart1.
+This example sets the marker background (fill) and foreground (border) colors for the first point in series one on Chart1.
+
+```vb
+With Charts("Chart1").SeriesCollection(1).Points(1) 
+ .MarkerBackgroundColor = RGB(0,255,0) ' green fill
+ .MarkerForegroundColor = RGB(255,0,0) ' red border
+End With
+```
+
+This example sets the marker colors to automatic for the second point in series one on Chart1.
 
 ```vb
 With Charts("Chart1").SeriesCollection(1).Points(2) 
- .MarkerBackgroundColor = RGB(0,255,0) ' green 
- .MarkerForegroundColor = RGB(255,0,0) ' red 
+ .MarkerBackgroundColor = -1 ' automatic fill
+ .MarkerForegroundColor = -1 ' automatic border
 End With
 ```
 
 
 
-[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
+[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
diff --git a/api/Excel.workbookquery.delete.md b/api/Excel.workbookquery.delete.md
@@ -4,7 +4,7 @@ keywords: vbaxl10.chm974077
 f1_keywords:
 - vbaxl10.chm974077
 ms.assetid: 05f42f34-1814-870f-081a-c0538b438aec
-ms.date: 05/18/2019
+ms.date: 12/29/2021
 ms.prod: excel
 ms.localizationpriority: medium
 ---
@@ -34,7 +34,8 @@ _expression_ A variable that represents a **[WorkbookQuery](Excel.WorkbookQuery.
 **Nothing**
 
 
+## Remarks
 
+By default, the underlying connection is not deleted. To delete both the query and the underlying connection, add the parameter (TRUE).
 
-
-[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
+[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
diff --git a/api/Excel.workbookquery.md b/api/Excel.workbookquery.md
@@ -17,6 +17,7 @@ An object that represents a query that was created by Power Query. Introduced in
 ## Methods
 
 - [Delete](Excel.workbookquery.delete.md)
+- [Refresh](Excel.workbookquery.refresh.md)
 
 ## Properties
 

diff --git a/api/Office.FileDialog.md b/api/Office.FileDialog.md
@@ -19,7 +19,7 @@ Provides file dialog box functionality similar to the functionality of the stand
 
 ## Remarks
 
-Use the **FileDialog** property to return a **FileDialog** object. The **FileDialog** property is located in each individual Office application's **Application** object. The property takes a single argument, _DialogType_, that determines the type of **FileDialog** object that the property returns. There are four types of **FileDialog** object:
+Use the **FileDialog** property to return a **FileDialog** object. The **FileDialog** property is located in each individual Office application's **Application** object. The property takes a single argument, [MsoFileDialogType](Office.MsoFileDialogType.md), that determines the type of **FileDialog** object that the property returns. There are four types of **FileDialog** object:
 
 - **Open** dialog box: lets users select one or more files that you can then open in the host application by using the **Execute** method.
 

diff --git a/api/Office.MsoThemeColorSchemeIndex.md b/api/Office.MsoThemeColorSchemeIndex.md
@@ -30,4 +30,33 @@ Indicates the color scheme for an Office theme.
 |**msoThemeLight1**|2|Specifies color scheme Light 1.|
 |**msoThemeLight2**|4|Specifies color scheme Light 2.|
 
-[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
+# Remarks
+
+An Office Theme.ThemeColorShceme comprises two light colors, two dark colors, six accent colors and two colors for hyperlinked text. Use this enumeration to set or return the colors for the specified theme. When theme colors are assigned to the ColorFormat object for a shape, they are mapped via the [MsoThemeColorIndex enumeration](https://docs.microsoft.com/en-us/office/vba/api/office.msothemecolorindex). For PowerPoint this mapping takes into account whether the object is present on a light or dark background style for the slide. There are twelve background styles, six light and six dark. For a light background style, an object set to use msoThemeColorBackground1 will be assigned to the Dark 1 color from the theme. For the same object on one of the dark background styles, the Light 1 color is used for the same msoThemeColorBackground1 assignment.
+
+When programmatically assigning a theme color to an object, the MsoThemeColorIndex enumeration should be used, specifically values 13 to 16 for the first four colors of the theme. If values 1 to 4 are used then the Office colour picker UI will not correctly highlight the theme color.
+
+# Example
+
+The following example outputs the Hex color values in BGR format for the twelve colors in the theme for the first slide master in the active presentation, in the order in which they appear in the Office theme editor UI.
+
+```vb
+Sub ShowThemeColors()
+    With ActivePresentation.Designs(1).SlideMaster.Theme
+        Debug.Print Hex(.ThemeColorScheme(msoThemeLight1).RGB)  ' 2
+        Debug.Print Hex(.ThemeColorScheme(msoThemeDark1).RGB)   ' 1
+        Debug.Print Hex(.ThemeColorScheme(msoThemeLight2).RGB)  ' 4
+        Debug.Print Hex(.ThemeColorScheme(msoThemeDark2).RGB)   ' 3
+        Debug.Print Hex(.ThemeColorScheme(msoThemeAccent1).RGB)
+        Debug.Print Hex(.ThemeColorScheme(msoThemeAccent2).RGB)
+        Debug.Print Hex(.ThemeColorScheme(msoThemeAccent3).RGB)
+        Debug.Print Hex(.ThemeColorScheme(msoThemeAccent4).RGB)
+        Debug.Print Hex(.ThemeColorScheme(msoThemeAccent5).RGB)
+        Debug.Print Hex(.ThemeColorScheme(msoThemeHyperlink).RGB)
+        Debug.Print Hex(.ThemeColorScheme(msoThemeAccent6).RGB)
+        Debug.Print Hex(.ThemeColorScheme(msoThemeFollowedHyperlink).RGB)
+    End With
+End Sub
+```
+
+[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
diff --git a/api/PowerPoint.ColorFormat.RGB.md b/api/PowerPoint.ColorFormat.RGB.md
@@ -26,23 +26,23 @@ _expression_ A variable that represents a [ColorFormat](PowerPoint.ColorFormat.m
 
 ## Return value
 
-MsoThemeColorSchemeIndex
+Long
 
 
 ## Example
 
-This example sets the background color for color scheme three in the active presentation and then applies the color scheme to all slides in the presentation that are based on the slide master.
+This example sets the background color for the first shape on the first slide of the active presentation to red and Accent 1 to green in the theme for the first slide master.
 
 
 ```vb
 With ActivePresentation
+    Dim oCF As ColorFormat
+
+    Set oCF = .Slides(1).Shapes(1).Fill.ForeColor
+
+    oCF.RGB = RGB(255, 0, 0)
 
-    Set cs1 = .ColorSchemes(3)
-
-    cs1.Colors(ppBackground).RGB = RGB(128, 128, 0)
-
-    .SlideMaster.ColorScheme = cs1
-
+    .Designs(1).SlideMaster.Theme.ThemeColorScheme(msoThemeAccent1).RGB = RGB(0, 255, 0)
 End With
 ```
 
@@ -52,4 +52,4 @@ End With
 
 [ColorFormat Object](PowerPoint.ColorFormat.md)
 
-[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
+[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
diff --git a/api/PowerPoint.ColorFormat.SchemeColor.md b/api/PowerPoint.ColorFormat.SchemeColor.md
@@ -14,7 +14,7 @@ ms.localizationpriority: medium
 
 # ColorFormat.SchemeColor property (PowerPoint)
 
-Returns or sets the color in the applied color scheme that's associated with the specified object. Read/write.
+Returns or sets the color in the applied legacy color scheme that's associated with the specified object. Provided for backwards compatibility. Use the [ObjectThemeColor] instead for Office 2007 and later. Read/write.
 
 
 ## Syntax
@@ -80,4 +80,4 @@ End With
 
 [ColorFormat Object](PowerPoint.ColorFormat.md)
 
-[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
+[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
diff --git a/api/PowerPoint.ColorFormat.md b/api/PowerPoint.ColorFormat.md
@@ -14,7 +14,7 @@ ms.localizationpriority: medium
 
 # ColorFormat object (PowerPoint)
 
-Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color. You can set colors to an explicit red-green-blue value (by using the [RGB](PowerPoint.ColorFormat.RGB.md) property) or to a color in the color scheme (by using the [SchemeColor](PowerPoint.ColorFormat.SchemeColor.md) property).
+Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color. You can set colors to an explicit red-green-blue value (by using the [RGB](PowerPoint.ColorFormat.RGB.md) property) or to a color in the theme (by using the [ObjectThemeColor]) or the legacy pre-Office 2007 color scheme (by using the [SchemeColor](PowerPoint.ColorFormat.SchemeColor.md) property).
 
 
 ## Remarks
@@ -65,4 +65,4 @@ End With
 
 [PowerPoint Object Model Reference](overview/PowerPoint/object-model.md)
 
-[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
+[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
diff --git a/api/PowerPoint.DocumentWindow.RangeFromPoint.md b/api/PowerPoint.DocumentWindow.RangeFromPoint.md
@@ -35,7 +35,7 @@ _expression_ A variable that represents a [DocumentWindow](PowerPoint.DocumentWi
 
 ## Example
 
-This example adds a new five-point star to slide one using the coordinates (288, 100). It then converts those coordinates from points to pixels, uses the  **RangeFromPoint** method to return a reference to the new object, and changes the fill color of the star.
+This example adds a new five-point star to slide one using the coordinates (288, 100). It then converts those coordinates from points to pixels, uses the  **RangeFromPoint** method to return a reference to the new object, and changes the fill color of the star. Note that the example does not work unless you step through the code, possibly pointing to a bug with the method. The penultimate line to set a reference to the object myShape fails at runtime unless stepping through the code.
 
 
 ```vb
@@ -57,4 +57,4 @@ myShape.Fill.ForeColor.RGB = RGB(80, 160, 130)
 
 [DocumentWindow Object](PowerPoint.DocumentWindow.md)
 
-[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
+[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
diff --git a/api/PowerPoint.Presentation.DefaultLanguageID.md b/api/PowerPoint.Presentation.DefaultLanguageID.md
@@ -31,7 +31,7 @@ MsoLanguageID
 
 ## Remarks
 
-When you set the  **DefaultLanguageID** property for a presentation, you set it for all subsequent new presentations as well.
+When you set the  **DefaultLanguageID** property for a presentation, you set it for all open and all subsequent new presentations as well.
 
 The value of the  **DefaultLanguageID** property can be one of these **MsoLanguageID** constants.
 
@@ -218,7 +218,7 @@ The value of the  **DefaultLanguageID** property can be one of these **MsoLangua
 
 ## Example
 
-This example sets the default language for the active presentation, and all subsequent new presentations, to German.
+This example sets the default language for the active presentation, all open presentations, and all subsequent new presentations, to German.
 
 
 ```vb
@@ -231,4 +231,4 @@ ActivePresentation.DefaultLanguageID = msoLanguageIDGerman
 
 [Presentation Object](PowerPoint.Presentation.md)
 
-[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
+[!include[Support and feedback](~/includes/feedback-boilerplate.md)]