PickerProperties.Add method (Office)
Adds a PickerProperty object to the collection.
Syntax
expression.Add (Id, Value, Type)
expression An expression that returns a PickerProperties object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Id | Required | String | Key name of the property. |
| Value | Required | String | Value of the property. |
| Type | Required | MsoPickerField | Type of the property. |
Return value
PickerProperty
Example
The following code sets various properties of the PickerDialog object.
Dim objPickerDialog As PickerDialog
Dim objPickerProperties As PickerProperties
' Configure Picker Dialog properties.
Set objPickerDialog = Application.PickerDialog
objPickerDialog.DataHandlerId = "{000CDF0A-0000-0000-C000-000000000046}"
objPickerDialog.Title = "Sample Picker Dialog"
Set objPickerProperties = objPickerDialog.Properties
Set objPickerProperty = objPickerProperties.Add("SiteUrl", "https://my", msoPickerFieldtypeText)
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.