Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merge master to live #33

Merged
merged 172 commits into from
Aug 16, 2018
Merged
Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
172 commits
Select commit Hold shift + click to select a range
6e56072
Initialize open publishing repository: https://github.com/MicrosoftDo…
Apr 24, 2018
fad2c04
add Access
Apr 24, 2018
b1acdcc
add latest object model docs
May 9, 2018
1f7e49c
add images from VBA content
May 9, 2018
2f3bf74
Access Renaming with existing api name
May 11, 2018
baa2901
Rename title and update content
May 14, 2018
f83196f
update links
May 14, 2018
fc185d7
correct more links
May 14, 2018
8724ee4
Rename Outlook step1
May 15, 2018
69d7f1c
rename outlook - step2
May 15, 2018
c4e7c97
update contents
May 15, 2018
8742f6f
update PowerPoint
May 15, 2018
25ba499
rename and update Project
May 15, 2018
630d8ca
rename and update - publisher
May 15, 2018
e65b8d2
Rename and update content
May 15, 2018
0e69536
rename and update
May 16, 2018
874fe0e
update content 2
May 16, 2018
a2f510c
update content 2
May 16, 2018
c3549c9
update content 2
May 16, 2018
4a9a86b
Update content 2
May 16, 2018
8e3c994
Rename and Update
May 16, 2018
bfda0e7
Revert "Access Renaming with existing api name"
May 16, 2018
f6e0aeb
Merge branch 'AccessUpdating' of https://github.com/MicrosoftDocs/VBA…
May 16, 2018
349e7d7
Merge pull request #8 from MicrosoftDocs/ExcelUpdating
May 16, 2018
07adb0f
Merge pull request #7 from MicrosoftDocs/OutlookUpdating
May 16, 2018
8f69d7a
Merge pull request #6 from MicrosoftDocs/PowerpointUpdating
May 16, 2018
71dbcda
Merge pull request #5 from MicrosoftDocs/Project
May 16, 2018
1a4c881
Merge pull request #4 from MicrosoftDocs/PublisherUpdating
May 16, 2018
a81cf0e
Merge pull request #3 from MicrosoftDocs/VisioUpdating
May 16, 2018
0fe4f43
Merge pull request #2 from MicrosoftDocs/WordUpdating
May 16, 2018
8be8ca8
Initialize open publishing repository: https://github.com/MicrosoftDo…
May 17, 2018
9099c35
Update .openpublishing.publish.config.json
May 17, 2018
2ca1acc
move docfx to root
May 17, 2018
a1411a6
update docfx
May 17, 2018
da9bed2
Update docfx.json
May 17, 2018
fe76877
Merge pull request #11 from MicrosoftDocs/update_docfx
May 17, 2018
7a5a335
UpdateTOC and copy concepts
Jun 1, 2018
d14d562
Merge pull request #12 from MicrosoftDocs/UpdateTOC
Jun 1, 2018
0478677
add all remaining files and folders
Jun 1, 2018
215b0b8
Merge pull request #13 from MicrosoftDocs/AddRemainings
Jun 1, 2018
e959f09
Update docfx.json
dend Jun 5, 2018
1e527c7
resfine-part1
Jun 12, 2018
d21ef73
rename folder
Jun 12, 2018
1fc0cec
fix
Jun 12, 2018
22aa078
remainings
Jun 13, 2018
c51eeae
remaining last
Jun 13, 2018
8dada96
remove ####concepts
Saisang Jun 14, 2018
00eb0be
add vb in code title
Saisang Jun 14, 2018
32a35bb
Merge pull request #14 from Saisang/sai-formatbulkupdate
Jun 15, 2018
1e45591
fix tables
Jun 18, 2018
3678173
Merge branch 'master' of https://github.com/MicrosoftDocs/VBA-Docs
Jun 18, 2018
d2b09fb
update images locations
Jun 18, 2018
f3a2464
update syntax part 1
Jun 19, 2018
89a5d78
syntax part1.1
Jun 19, 2018
6095c04
syntax part 1.2
Jun 19, 2018
2039954
add sub level for Properties, methods and events in toc
Saisang Jun 20, 2018
c5dc7b9
Merge pull request #16 from MicrosoftDocs/sai-tocsublevel
Jun 20, 2018
b98d43c
testscript
Jun 21, 2018
1f84aa7
synctax part2 -access
Jun 21, 2018
88ce457
syntax part2 - others
Jun 21, 2018
b85fa3f
Merge pull request #17 from MicrosoftDocs/syntax-part2
Jun 21, 2018
8cd27c3
remove the Other Resources label
Jun 22, 2018
7bf823f
Incorrect single tick used
Jun 22, 2018
f2db4ca
fix table format
Jun 22, 2018
a84286c
fix table 2
Jun 22, 2018
92e610c
Sai regression bugs fix (#18)
Saisang Jun 22, 2018
d514506
move references to the end of the list
Saisang Jun 22, 2018
ce6d9df
Merge pull request #19 from MicrosoftDocs/sai-movetoc
Saisang Jun 22, 2018
bf4be8e
fix libraryReferences
Jun 25, 2018
36f2be5
move libraryRefence
Jun 25, 2018
c76ec45
fix overviews
Jun 25, 2018
c571ba0
remove empty anchor
Saisang Jun 26, 2018
b885041
correct links
Jun 26, 2018
3371695
redirect msdn links to docs
Saisang Jun 26, 2018
134e6a4
Merge branch 'master' into sai-redirectmsdntodocs
Saisang Jun 26, 2018
0e25125
correct links
Jun 26, 2018
50e0c79
Merge pull request #20 from MicrosoftDocs/sai-redirectmsdntodocs
Saisang Jun 26, 2018
f6ec7c1
fix warnings and missing files
Jun 27, 2018
c64c359
Merge branch 'master' of https://github.com/MicrosoftDocs/VBA-Docs
Jun 27, 2018
7c72105
add missing
Jun 27, 2018
15253d4
redirect to docs
Saisang Jun 27, 2018
28f8969
update TOC
Jun 27, 2018
8a53d10
manual redirection fixing typo
Saisang Jun 28, 2018
dc20894
manually redirect
Saisang Jun 28, 2018
3626325
redirect msdn links which docs topics are missing to landing pages
Saisang Jun 28, 2018
282d820
Merge pull request #21 from MicrosoftDocs/sai-redirectiontolandings
Saisang Jun 28, 2018
3c02533
fix links
Jun 28, 2018
287b333
resolve conflicts
Jun 28, 2018
bbc8baa
update links
Jun 29, 2018
2389d0b
fix links
Jun 29, 2018
2289814
fix language reference links
Jun 29, 2018
372a957
correct links
Jun 29, 2018
b7629cc
add missing fixes
Jun 29, 2018
8cd1e48
remove 4 wrong copy files - api
Jul 2, 2018
6cd63e6
copy missing files from source code
Saisang Jul 2, 2018
2082425
Merge bug fixes to master (#22)
Linda-Editor Jul 3, 2018
4cf3e3a
fix missing files in api
Jul 3, 2018
e5bbaf9
resolve missing
Jul 3, 2018
ae37e8b
correct links
Jul 3, 2018
c8c38e7
fix merge conflict
Jul 3, 2018
17c44a3
Merge pull request #23 from MicrosoftDocs/sai-copymissingfiles
Jul 3, 2018
633e232
remove dulplicated toc nodes
Saisang Jul 3, 2018
39e39d3
fix links
Jul 3, 2018
8072e43
change structure language-reference/language-reference/ to language/r…
Saisang Jul 4, 2018
ac9b6a3
Merge branch 'master' of https://github.com/MicrosoftDocs/VBA-Docs in…
Saisang Jul 4, 2018
ddbe412
fix typo in toc
Saisang Jul 4, 2018
173904a
move overview topics into product sub folders
Saisang Jul 4, 2018
86d964a
update due to renaming
Jul 4, 2018
c0d64cf
correct file name
Jul 4, 2018
3e4fb06
fix links
Jul 4, 2018
3e0fa3b
fix typo in toc
Saisang Jul 4, 2018
a4fd4a0
scan and fix broken links
Saisang Jul 4, 2018
5457590
fix broken links
Saisang Jul 4, 2018
da04147
Merge branch 'master' of https://github.com/MicrosoftDocs/VBA-Docs in…
Saisang Jul 4, 2018
702b4d8
fix broken links
Saisang Jul 5, 2018
042e605
fix broken links
Saisang Jul 5, 2018
815d722
Merge pull request #24 from MicrosoftDocs/sai-dulptocnodefix
Jul 5, 2018
3c87271
add missing files'
Jul 5, 2018
945bfa8
Merge branch 'master' of https://github.com/MicrosoftDocs/VBA-Docs
Jul 5, 2018
e07cf44
fix typo and missings
Jul 5, 2018
58e5871
update breadcrumb
Jul 5, 2018
2127ab1
lastwarning
Jul 5, 2018
317a547
fix remaining tables
Jul 5, 2018
e8508ab
remove object model dulp file
Saisang Jul 5, 2018
bf0f67f
remove dulp toc
Saisang Jul 5, 2018
7ec4e7b
delete dulp files
Saisang Jul 6, 2018
cd6bd04
redirecttion after removing
Saisang Jul 6, 2018
77a1be1
Merge pull request #26 from MicrosoftDocs/sai-removedulpfiles
Saisang Jul 6, 2018
d3239d3
remove dulp toc
Saisang Jul 9, 2018
26e8f32
fix meta & image alt
Jul 9, 2018
7b3c7f6
insert files which missing toc
Saisang Jul 9, 2018
caea202
https checking
Jul 9, 2018
65e79f4
insert missing toc files manually
Saisang Jul 9, 2018
c7b7759
Merge pull request #27 from MicrosoftDocs/sai-removedulptoc
Saisang Jul 9, 2018
c8bbec8
Merge "missing language specification" fixes (#28)
Linda-Editor Jul 10, 2018
ea7f86e
Fixed merge conflict
Linda-Editor Jul 11, 2018
4e84274
Fix code block
Linda-Editor Jul 11, 2018
833b457
Fix code, take 2
Linda-Editor Jul 11, 2018
ffcb8d2
Fixed missing lang spec
Linda-Editor Jul 11, 2018
7f07dea
Fixed bullet and NOTE formatting
Linda-Editor Jul 11, 2018
6344fce
update http
Jul 11, 2018
4756487
merge conflicts
Jul 11, 2018
9f09952
match case sensitive
Saisang Jul 11, 2018
11667e6
add missing toc manually
Saisang Jul 11, 2018
c22d967
fix some typo
Saisang Jul 11, 2018
2742f79
fix some typo
Saisang Jul 11, 2018
72db72d
Merge pull request #29 from MicrosoftDocs/sai-missingtoc
Saisang Jul 11, 2018
1df32b8
🔒 HTTPS link changes
Jul 12, 2018
fad7f1a
✅ Content fixes.
Jul 12, 2018
7f5cd9d
📢 GitHub feedback.
Jul 12, 2018
2c82621
Fixed See also link
Linda-Editor Jul 19, 2018
c8c1035
fix typo in toc
Saisang Aug 1, 2018
1693725
Merge pull request #30 from MicrosoftDocs/sai-fixtypointoc
Saisang Aug 1, 2018
5ac3f51
delete duplicated files and fix the toc links
Saisang Aug 2, 2018
833f942
fix broken links after deleting files.
Saisang Aug 2, 2018
0f8ea97
fix broken links after deleting files.
Saisang Aug 2, 2018
ce882b1
Updated headings to match other glossary
Aug 2, 2018
fd5cb9d
Merge pull request #31 from MicrosoftDocs/sai-removeduplicatefilesbys…
Saisang Aug 3, 2018
5692e71
Made glossaries consistent
Aug 3, 2018
4840b20
copy F1 Landing folder
Saisang Aug 6, 2018
64d523b
copy F1 Landing folder
Saisang Aug 6, 2018
977230b
copy other files according to missing guid
Saisang Aug 6, 2018
5010d52
move files into correct path
Saisang Aug 6, 2018
15d09e5
fix broken links
Saisang Aug 7, 2018
332bdf3
fix broken links
Saisang Aug 7, 2018
22044b3
Merge pull request #32 from MicrosoftDocs/sai-addF1LandingPages
Saisang Aug 7, 2018
4054a08
Added ROBOTS for F1 and misc. topics
Aug 9, 2018
bfe75ca
Added YAML metadata
Aug 9, 2018
8eba74d
Merge branch 'master' of https://github.com/MicrosoftDocs/VBA-Docs
Aug 9, 2018
9ed099c
Changed Office-F1-Landing to F1
Aug 16, 2018
851cb43
Updated F1 under ROBOTS
Aug 16, 2018
2b4277e
Merge branch 'live' into master
Aug 16, 2018
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
redirecttion after removing
  • Loading branch information
Saisang committed Jul 6, 2018
commit cd6bd048b4456ad4512eb762254e2390d05ac0d0
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@ ms.date: 06/08/2017



Sets or retrieves the [accelerator key](glossary-vba.md) for a control.
Sets or retrieves the [accelerator key](../../../language/Glossary/glossary-vba.md) for a control.
**Syntax**
_object_. **Accelerator** [= _String_ ]
The **Accelerator** property syntax has these parts:
Expand Down
Original file line number Diff line number Diff line change
Expand Up @@ -26,6 +26,6 @@ The **AfterUpdate** event syntax has these parts:
| _object_|Required. A valid object.|

**Remarks**
The AfterUpdate event occurs regardless of whether the control is [bound](glossary-vba.md) (that is, when the **RowSource** property specifies a[data source](glossary-vba.md) for the control). This event cannot be canceled. If you want to cancel the update (to restore the previous value of the control), use the BeforeUpdate event and set the _Cancel_ argument to **True**.
The AfterUpdate event occurs regardless of whether the control is [bound](../../../language/Glossary/glossary-vba.md) (that is, when the **RowSource** property specifies a[data source](../../../language/Glossary/glossary-vba.md) for the control). This event cannot be canceled. If you want to cancel the update (to restore the previous value of the control), use the BeforeUpdate event and set the _Cancel_ argument to **True**.
The AfterUpdate event occurs after the BeforeUpdate event and before the Exit event for the current control and before the Enter event for the next control in the [tab order](vbe-glossary.md).

Original file line number Diff line number Diff line change
Expand Up @@ -13,7 +13,7 @@ ms.date: 06/08/2017



Specifies the [background color](glossary-vba.md) of the object.
Specifies the [background color](../../../language/Glossary/glossary-vba.md) of the object.
**Syntax**
_object_. **BackColor** [= _Long_ ]
The **BackColor** property syntax has these parts:
Expand All @@ -25,7 +25,7 @@ The **BackColor** property syntax has these parts:
| _Long_|Optional. A value or constant that determines the background color of an object.|

**Settings**
You can use any integer that represents a valid color. You can also specify a color by using the [RGB](glossary-vba.md) function with red, green, and blue color components. The value of each color component is an integer that ranges from zero to 255. For example, you can specify teal blue as the integer value 4966415 or as red, green, and blue color components 15, 200, 75.
You can use any integer that represents a valid color. You can also specify a color by using the [RGB](../../../language/Glossary/glossary-vba.md) function with red, green, and blue color components. The value of each color component is an integer that ranges from zero to 255. For example, you can specify teal blue as the integer value 4966415 or as red, green, and blue color components 15, 200, 75.
**Remarks**
You can only see the background color of an object if the **BackStyle** property is set to **fmBackStyleOpaque**.

Original file line number Diff line number Diff line change
Expand Up @@ -34,7 +34,7 @@ The settings for _fmBackStyle_ are:
| _fmBackStyleOpaque_|1|The background is opaque (default).|

**Remarks**
The **BackStyle** property determines whether a control is[transparent](glossary-vba.md). If **BackStyle** is **fmBackStyleOpaque**, the control is not transparent and you cannot see anything behind the control on a form. If **BackStyle** is **fmBackStyleTransparent**, you can see through the control and look at anything on the form located behind the control.
The **BackStyle** property determines whether a control is[transparent](../../../language/Glossary/glossary-vba.md). If **BackStyle** is **fmBackStyleOpaque**, the control is not transparent and you cannot see anything behind the control on a form. If **BackStyle** is **fmBackStyleTransparent**, you can see through the control and look at anything on the form located behind the control.

**Note** **BackStyle** does not affect the transparency of bitmaps. You must use a picture editor such as Paintbrush to make a bitmap transparent. Not all controls support transparent bitmaps.

Expand Down
Original file line number Diff line number Diff line change
Expand Up @@ -33,7 +33,7 @@ The **BeforeDragOver** event syntax has these parts:
| _Data_|Required. Data that is dragged in a drag-and-drop operation. The data is packaged in a **DataObject**.|
| _X, Y_|Required. The horizontal and vertical coordinates of the control's position. Both coordinates are measured in points. _X_ is measured from the left edge of the control; _Y_ is measured from the top of the control..|
| _DragState_|Required. Transition state of the data being dragged.|
| _Effect_|Required. Operations supported by the [drop source](glossary-vba.md).|
| _Effect_|Required. Operations supported by the [drop source](../../../language/Glossary/glossary-vba.md).|
| _Shift_|Required. Specifies the state of SHIFT, CTRL, and ALT.|

**Settings**
Expand Down Expand Up @@ -66,7 +66,7 @@ The settings for _Shift_ are:
| _fmAltMask_|4|ALT was pressed.|

**Remarks**
Use this event to monitor the mouse pointer as it enters, leaves, or rests directly over a valid [target](glossary-vba.md). When a drag-and-drop operation is in progress, the system initiates this event when the user moves the mouse, or presses or releases the mouse button or buttons. The mouse pointer position determines the target object that receives this event. You can determine the state of the mouse pointer by examining the _DragState_ argument.
Use this event to monitor the mouse pointer as it enters, leaves, or rests directly over a valid [target](../../../language/Glossary/glossary-vba.md). When a drag-and-drop operation is in progress, the system initiates this event when the user moves the mouse, or presses or releases the mouse button or buttons. The mouse pointer position determines the target object that receives this event. You can determine the state of the mouse pointer by examining the _DragState_ argument.
When a control handles this event, you can use the _Effect_ argument to identify the drag-and-drop action to perform. When _Effect_ is set to **fmDropEffectCopyOrMove**, the drop source supports a copy ( **fmDropEffectCopy** ), move ( **fmDropEffectMove** ), or a cancel ( **fmDropEffectNone** ) operation.
When _Effect_ is set to **fmDropEffectCopy**, the drop source supports a copy or a cancel ( **fmDropEffectNone** ) operation.
When _Effect_ is set to **fmDropEffectMove**, the drop source supports a move or a cancel ( **fmDropEffectNone** ) operation.
Expand Down
Original file line number Diff line number Diff line change
Expand Up @@ -50,7 +50,7 @@ The settings for _Effect_ are:

|**Constant**|**Value**|**Description**|
|:-----|:-----|:-----|
| _fmDropEffectNone_|0|Does not copy or move the [drop source](glossary-vba.md) to the drop target.|
| _fmDropEffectNone_|0|Does not copy or move the [drop source](../../../language/Glossary/glossary-vba.md) to the drop target.|
| _fmDropEffectCopy_|1|Copies the drop source to the drop target.|
| _fmDropEffectMove_|2|Moves the drop source to the drop target.|
| _fmDropEffectCopyOrMove_|3|Copies or moves the drop source to the drop target.|
Expand Down
Original file line number Diff line number Diff line change
Expand Up @@ -27,6 +27,6 @@ The **BeforeUpdate** event syntax has these parts:
| _Cancel_|Required. Event status. **False** indicates that the control should handle the event (default). **True** cancels the update and indicates the application should handle the event.|

**Remarks**
The BeforeUpdate event occurs regardless of whether the control is [bound](glossary-vba.md) (that is, when the **RowSource** property specifies a[data source](glossary-vba.md) for the control). This event occurs before the AfterUpdate and Exit events for the control (and before the Enter event for the next control that receives[focus](vbe-glossary.md)).
The BeforeUpdate event occurs regardless of whether the control is [bound](../../../language/Glossary/glossary-vba.md) (that is, when the **RowSource** property specifies a[data source](../../../language/Glossary/glossary-vba.md) for the control). This event occurs before the AfterUpdate and Exit events for the control (and before the Enter event for the next control that receives[focus](vbe-glossary.md)).
If you set the _Cancel_ argument to **True**, the focus remains on the control and neither the AfterUpdate event nor the Exit event occurs.

Original file line number Diff line number Diff line change
Expand Up @@ -27,8 +27,8 @@ The **BorderColor** property syntax has these parts:
| _Long_|Optional. A value or constant that determines the border color of an object.|

**Settings**
You can use any integer that represents a valid color. You can also specify a color by using the [RGB](glossary-vba.md) function with red, green, and blue color components. The value of each color component is an integer that ranges from zero to 255. For example, you can specify teal blue as the integer value 4966415 or as RGB color component values 15, 200, 75.
You can use any integer that represents a valid color. You can also specify a color by using the [RGB](../../../language/Glossary/glossary-vba.md) function with red, green, and blue color components. The value of each color component is an integer that ranges from zero to 255. For example, you can specify teal blue as the integer value 4966415 or as RGB color component values 15, 200, 75.
**Remarks**
To use the **BorderColor** property, the **BorderStyle** property must be set to a value other than **fmBorderStyleNone**.
**BorderStyle** uses **BorderColor** to define the border colors. The **SpecialEffect** property uses[system colors](glossary-vba.md) exclusively to define its border colors. For Windows operating systems, system color settings are part of the **Control Panel** and are found in the **Appearance** tab of the **Display** folder. In Windows NT 4.0 or later, system color settings are stored in the **Color** folder of the **Control Panel**.
**BorderStyle** uses **BorderColor** to define the border colors. The **SpecialEffect** property uses[system colors](../../../language/Glossary/glossary-vba.md) exclusively to define its border colors. For Windows operating systems, system color settings are part of the **Control Panel** and are found in the **Appearance** tab of the **Display** folder. In Windows NT 4.0 or later, system color settings are stored in the **Color** folder of the **Control Panel**.

Original file line number Diff line number Diff line change
Expand Up @@ -38,7 +38,7 @@ The settings for _Variant_ are:
**Remarks**
When the user chooses a row in a multicolumn **ListBox** or **ComboBox**, the **BoundColumn** property identifies which item from that row to store as the value of the control. For example, if each row contains 8 items and **BoundColumn** is 3, the system stores the information in the third column of the currently-selected row as the value of the object.
You can display one set of data to users but store different, associated values for the object by using the **BoundColumn** and the **TextColumn** properties. **TextColumn** identifies the column of data displayed in text box portion of a **ComboBox** and the value stored in the **Text** property; **BoundColumn** identifies the column of associated data values stored for the control. For example, you could set up a multicolumn **ListBox** that contains the names of holidays in one column and dates for the holidays in a second column. To present the holiday names to users, specify the first column as the **TextColumn**. To store the dates of the holidays, specify the second column as the **BoundColumn**. To hide the dates of the holidays, set the **ColumnWidths** property of the sceond column to zero.
If the control is [bound](glossary-vba.md) to a[data source](glossary-vba.md), the value in the column specified by **BoundColumn** is stored in the data source named in the **ControlSource** property.
If the control is [bound](../../../language/Glossary/glossary-vba.md) to a[data source](../../../language/Glossary/glossary-vba.md), the value in the column specified by **BoundColumn** is stored in the data source named in the **ControlSource** property.
The **ListIndex** value retrieves the number of the selected row. For example, if you want to know the row of the selected item, set **BoundColumn** to 0 to assign the number of the selected row as the value of the control. Be sure to retrieve a current value, rather than relying on a previously saved value, if you are referencing a list whose contents might change.
The **Column**, **List**, and **ListIndex** properties all use zero-based numbering. That is, the value of the first item (column or row) is zero; the value of the second item is one, and so on. This means that if **BoundColumn** is set to 3, you could access the value stored in that column using the expression Column(2).

Original file line number Diff line number Diff line change
Expand Up @@ -32,7 +32,7 @@ The **BoundValue** property syntax has these parts:
|**Control**|**Description**|
|:-----|:-----|
|**CheckBox**|An integer value indicating whether the item is selected:|
||Null Indicates the item is in a null state, neither selected nor [cleared](glossary-vba.md).|
||Null Indicates the item is in a null state, neither selected nor [cleared](../../../language/Glossary/glossary-vba.md).|
||-1 True. Indicates the item is selected.|
||0 False. Indicates the item is cleared.|
|**OptionButton**|Same as **CheckBox**.|
Expand Down
Original file line number Diff line number Diff line change
Expand Up @@ -34,7 +34,7 @@ The settings for _Boolean_ are:
|**False**|The **CommandButton** is not the Cancel button (default).|

**Remarks**
A **CommandButton** or an object that acts like a command button can be designated as the default command button. For[OLE container controls](glossary-vba.md) (Windows only), the **Cancel** property is provided only for those objects that specifically behave as command buttons.
A **CommandButton** or an object that acts like a command button can be designated as the default command button. For[OLE container controls](../../../language/Glossary/glossary-vba.md) (Windows only), the **Cancel** property is provided only for those objects that specifically behave as command buttons.
Only one **CommandButton** on a form can be the Cancel button. Setting **Cancel** to **True** for one command button automatically sets it to **False** for all other objects on the form. When a **CommandButton's Cancel** property is set to **True** and the form is the active form, the user can choose the command button by clicking it, pressing ESC, or pressing ENTER when the button has the[focus](vbe-glossary.md).
A typical use of **Cancel** is to give the user the option of canceling uncommitted changes and returning the form to its previous state.
You should consider making the Cancel button the default button for forms that support operations that can't be undone (such as delete). To do this, set both **Cancel** and the **Default** property to **True**.
Expand Down
Original file line number Diff line number Diff line change
Expand Up @@ -36,5 +36,5 @@ The **CanPaste** property return values are:

**Remarks**
**CanPaste** is read-only.
If the Clipboard data is in a [format](glossary-vba.md) that the current[target](glossary-vba.md) object does not support, the **CanPaste** property is **False**. For example, if you try to paste a bitmap into an object that only supports text, **CanPaste** will be **False**.
If the Clipboard data is in a [format](../../../language/Glossary/glossary-vba.md) that the current[target](../../../language/Glossary/glossary-vba.md) object does not support, the **CanPaste** property is **False**. For example, if you try to paste a bitmap into an object that only supports text, **CanPaste** will be **False**.

2 changes: 1 addition & 1 deletion Language/Reference/User-Interface-Help/checkbox-control.md
Original file line number Diff line number Diff line change
Expand Up @@ -16,7 +16,7 @@ ms.date: 06/08/2017
Displays the selection state of an item.
**Remarks**
Use a **CheckBox** to give the user a choice between two values such as _Yes_ / _No_, _True_ / _False_, or _On_ / _Off_. When the user selects a **CheckBox**, it displays a special mark (such as an X) and its current setting is _Yes_, _True_, or _On_; if the user does not select the **CheckBox**, it is empty and its setting is _No_, _False_, or _Off_. Depending on the value of the **TripleState** property, a **CheckBox** can also have a[null](vbe-glossary.md) value.
If a **CheckBox** is[bound](glossary-vba.md) to a[data source](glossary-vba.md), changing the setting changes the value of that source. A disabled **CheckBox** shows the current value, but is dimmed and does not allow changes to the value from the user interface.
If a **CheckBox** is[bound](../../../language/Glossary/glossary-vba.md) to a[data source](../../../language/Glossary/glossary-vba.md), changing the setting changes the value of that source. A disabled **CheckBox** shows the current value, but is dimmed and does not allow changes to the value from the user interface.
You can also use check boxes inside a group box to select one or more of a group of related items. For example, you can create an order form that contains a list of available items, with a **CheckBox** preceding each item. The user can select a particular item or items by checking the corresponding **CheckBox**.
The default property of a **CheckBox** is the **Value** property.
The default event of a **CheckBox** is the Click event.
Expand Down
2 changes: 1 addition & 1 deletion Language/Reference/User-Interface-Help/click-event.md
Original file line number Diff line number Diff line change
Expand Up @@ -51,7 +51,7 @@ The following are examples of actions that initiate the Click event:

- Pressing ESC on a form that has a command button whose **Cancel** property is set to **True**, as long as no other command button has the focus.

- Pressing a control's [accelerator key](glossary-vba.md).
- Pressing a control's [accelerator key](../../../language/Glossary/glossary-vba.md).


When the Click event results from clicking a control, the sequence of events leading to the Click event is:
Expand Down
2 changes: 1 addition & 1 deletion Language/Reference/User-Interface-Help/column-property.md
Original file line number Diff line number Diff line change
Expand Up @@ -31,7 +31,7 @@ The **Column** property syntax has these parts:
**Settings**
If you specify both the column and row values, **Column** reads or writes a specific item.
If you specify only the column value, the **Column** property reads or writes the specified column in the current row of the object. For example, MyListBox.Column (3) reads or writes the third column in MyListBox.
**Column** returns a _Variant_ from the cursor. When a built-in[cursor](glossary-vba.md) provides the value for _Variant_ (such as when using the **AddItem** method), the value is a string. When an external cursor provides the value for _Variant_, formatting associated with the data is not included in the _Variant_.
**Column** returns a _Variant_ from the cursor. When a built-in[cursor](../../../language/Glossary/glossary-vba.md) provides the value for _Variant_ (such as when using the **AddItem** method), the value is a string. When an external cursor provides the value for _Variant_, formatting associated with the data is not included in the _Variant_.
**Remarks**
You can use **Column** to assign the contents of a combo box or list box to another control, such as a text box. For example, you can set the **ControlSource** property of a text box to the value in the second column of a list box.
If the user makes no selection when you refer to a column in a combo box or list box, the **Column** setting is **Null**. You can check for this condition by using the IsNull function.
Expand Down
Original file line number Diff line number Diff line change
Expand Up @@ -28,6 +28,6 @@ The **ColumnCount** property syntax has these parts:

**Remarks**
If you set the **ColumnCount** property for a list box to 3 on an employee form, one column can list last names, another can list first names, and the third can list employee ID numbers.
Setting **ColumnCount** to 0 displays zero columns, and setting it to -1 displays all the available columns. For an[unbound](glossary-vba.md)[data source](glossary-vba.md), there is a 10-column limit (0 to 9).
Setting **ColumnCount** to 0 displays zero columns, and setting it to -1 displays all the available columns. For an[unbound](../../../language/Glossary/glossary-vba.md)[data source](../../../language/Glossary/glossary-vba.md), there is a 10-column limit (0 to 9).
You can use the **ColumnWidths** property to set the width of the columns displayed in the control.

Loading