Microsoft Outlook’s Visual Basic for Applications macro programming language enables you to add a form to an email message that can collect data from its recipient. For example, you can insert a VBA UserForm and list box into your message that displays multiple items or options the recipient can choose from. Before you can add this feature to your messages, however, you need to add the Developer tab and its tools to the ribbon and change Outlook’s security settings to allow VBA macros to run. Private Sub CommandButton1_Click() ListBox1.AddItem “Red” ListBox1.AddItem “Green” ListBox1.AddItem “Blue” End Sub ListBox1 is the name Outlook automatically gives the list box you dragged to the UserForm. The statement ListBox1.AddItem “Red” makes Red the first item in the list box. Warnings Writer Bio
