Dropdown data list in view

SubSeaGuy · Joined: 13 Aug 2007 Posts: 3

I have added a custom field in my task form. Data is selected via a dropdown
menu. I have tested it and the data is retained with no problems. I have
also included my custom field in a list view. When I try to enter data in
this field via in-cell editing, my dropdown is not available. I can enter
data and it is retained but I would like the same dropdown menu available for
in-cell editing in the list view as is available on the form. Can this be
done and if so, how would I go about doing it?

Archived from group: microsoft>public>outlook>program_forms

Sue Mosher [MVP-Outlook] · Joined: 12 Aug 2007 Posts: 656

No, that cannot be done. Outlook does not support custom drop-down lists in folder views.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"SubSeaGuy" wrote in message @microsoft.com...
>I have added a custom field in my task form. Data is selected via a dropdown
> menu. I have tested it and the data is retained with no problems. I have
> also included my custom field in a list view. When I try to enter data in
> this field via in-cell editing, my dropdown is not available. I can enter
> data and it is retained but I would like the same dropdown menu available for
> in-cell editing in the list view as is available on the form. Can this be
> done and if so, how would I go about doing it?

SubSeaGuy · Joined: 13 Aug 2007 Posts: 3

Thanks Sue. How about a drop down in the toolbar to select from the list?
Any guidance on the best way to do that?

"Sue Mosher [MVP-Outlook]" wrote:

> No, that cannot be done. Outlook does not support custom drop-down lists in folder views.
>
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and Administrators
> http://www.outlookcode.com/article.aspx?id=54
>
>
> "SubSeaGuy" wrote in message @microsoft.com...
> >I have added a custom field in my task form. Data is selected via a dropdown
> > menu. I have tested it and the data is retained with no problems. I have
> > also included my custom field in a list view. When I try to enter data in
> > this field via in-cell editing, my dropdown is not available. I can enter
> > data and it is retained but I would like the same dropdown menu available for
> > in-cell editing in the list view as is available on the form. Can this be
> > done and if so, how would I go about doing it?
>

Sue Mosher [MVP-Outlook] · Joined: 12 Aug 2007 Posts: 656

Depends on whether this is for your personal use or something that needs to be distributed to other people.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"SubSeaGuy" wrote in message @microsoft.com...
> Thanks Sue. How about a drop down in the toolbar to select from the list?
> Any guidance on the best way to do that?
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> No, that cannot be done. Outlook does not support custom drop-down lists in folder views.
>>
>> "SubSeaGuy" wrote in message @microsoft.com...
>> >I have added a custom field in my task form. Data is selected via a dropdown
>> > menu. I have tested it and the data is retained with no problems. I have
>> > also included my custom field in a list view. When I try to enter data in
>> > this field via in-cell editing, my dropdown is not available. I can enter
>> > data and it is retained but I would like the same dropdown menu available for
>> > in-cell editing in the list view as is available on the form. Can this be
>> > done and if so, how would I go about doing it?
>>

SubSeaGuy · Joined: 13 Aug 2007 Posts: 3

Personal use only.

"Sue Mosher [MVP-Outlook]" wrote:

> Depends on whether this is for your personal use or something that needs to be distributed to other people.
>
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and Administrators
> http://www.outlookcode.com/article.aspx?id=54
>
>
> "SubSeaGuy" wrote in message @microsoft.com...
> > Thanks Sue. How about a drop down in the toolbar to select from the list?
> > Any guidance on the best way to do that?
> >
> > "Sue Mosher [MVP-Outlook]" wrote:
> >
> >> No, that cannot be done. Outlook does not support custom drop-down lists in folder views.
> >>
> >> "SubSeaGuy" wrote in message @microsoft.com...
> >> >I have added a custom field in my task form. Data is selected via a dropdown
> >> > menu. I have tested it and the data is retained with no problems. I have
> >> > also included my custom field in a list view. When I try to enter data in
> >> > this field via in-cell editing, my dropdown is not available. I can enter
> >> > data and it is retained but I would like the same dropdown menu available for
> >> > in-cell editing in the list view as is available on the form. Can this be
> >> > done and if so, how would I go about doing it?
> >>
>

Sue Mosher [MVP-Outlook] · Joined: 12 Aug 2007 Posts: 656

This VBA code sample creates a new button on the Standard toolbar when Outlook starts up and runs code when the button is clicked to update a custom property with the value the user selects from a dropdown list:

Dim WithEvents objCBC As Office.CommandBarComboBox

Private Sub Application_Startup()
Dim objExpl As Outlook.Explorer
Dim objCB As Office.CommandBar
On Error Resume Next
Set objExpl = Application.ActiveExplorer
Set objCB = objExpl.CommandBars("Standard")
Set objCBC = objCB.Controls.Add(Type:=msoControlComboBox, _
Temporary:=True)

' adapted from Help file
With objCBC
.AddItem "Get Stock Quote", 1
.AddItem "View Chart", 2
.AddItem "View Fundamentals", 3
.AddItem "View News", 4
.DescriptionText = "View Data For Stock"
.text = "Select option here"
.Width = 200
.Style = msoComboNormal
End With
Set objCB = Nothing
Set objExpl = Nothing
End Sub

Private Sub objCBC_Change(ByVal Ctrl As Office.CommandBarComboBox)
Dim objExpl As Outlook.Explorer
Dim objTask As Outlook.taskItem
Dim objProp As Outlook.UserProperty
Dim strPropName As String
On Error Resume Next
' set the name of the custom property here
strPropName = "My Custom Property Name"
Set objExpl = Application.ActiveExplorer
For Each objTask In objExpl.Selection
Set objProp = objTask.UserProperties(strPropName)
' if the property doesn't exist, create it
If objProp Is Nothing Then
Set objProp = _
objTask.UserProperties.Add(Name:=strPropName, _
Type:=olText)
End If
objProp.Value = objCBC.text
objTask.Save
Next
objCBC.text = "Select option here"
Set objProp = Nothing
Set objExpl = Nothing
Set objTask = Nothing
End Sub

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"SubSeaGuy" wrote in message @microsoft.com...
> Personal use only.
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> Depends on whether this is for your personal use or something that needs to be distributed to other people.
>>
>> --
>> Sue Mosher, Outlook MVP
>> Author of Microsoft Outlook 2007 Programming:
>> Jumpstart for Power Users and Administrators
>> http://www.outlookcode.com/article.aspx?id=54
>>
>>
>> "SubSeaGuy" wrote in message @microsoft.com...
>> > Thanks Sue. How about a drop down in the toolbar to select from the list?
>> > Any guidance on the best way to do that?
>> >
>> > "Sue Mosher [MVP-Outlook]" wrote:
>> >
>> >> No, that cannot be done. Outlook does not support custom drop-down lists in folder views.
>> >>
>> >> "SubSeaGuy" wrote in message @microsoft.com...
>> >> >I have added a custom field in my task form. Data is selected via a dropdown
>> >> > menu. I have tested it and the data is retained with no problems. I have
>> >> > also included my custom field in a list view. When I try to enter data in
>> >> > this field via in-cell editing, my dropdown is not available. I can enter
>> >> > data and it is retained but I would like the same dropdown menu available for
>> >> > in-cell editing in the list view as is available on the form. Can this be
>> >> > done and if so, how would I go about doing it?
>> >>
>>

Creating a dropdown box I am trying to create a custom form to be able to obtain general information from some of my users. I am trying to create a drop down menu with a short list of locations for the users to select. When I go into the properties of the list box and select new

Outlook 2003 Forms - Creating Dropdown lists I'm having trouble. I'm adapting an existing form to gather information from a number of folks on global sales pipeline I'll then import that data into a database. I'm able to create a number of fields, but I'm confused about creating a d

Data Can you program the information in an Outlook form to automatically be entered in to an Excel spreadsheet? -- eric

Field data available to all folders Using winxp & outlook 2003 I've created a customized contact & task forms. I'm having difficulty getting some of the data to populate from the contact form to the task form & the table view of the task form. Some of the fields are user-defined fields & s

Data in Combobox control vs. UDF Hi, This is a follow-up to a previous question I had regarding the values in a combobox on a custom form. I am populating the combobox through Access. Yet when I send the form, the values are not retained. I think I've narrowed down the p