PickerProperties.Add method (Office)

Adds a PickerProperty object to the collection.


expression.Add (Id, Value, Type)

expression An expression that returns a PickerProperties object.


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



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.