Edit

PickerProperties.Add method (Office)

  • Article

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.