Linking dropdown values

Status
Not open for further replies.
W

Wiggins

Is there an easy way to create a list of values in excel and then link to

this list in the dropdown box "Possible Values" in an Outlook form? I have

one dropdown box that will have many values and may change from time to time

so I don't want to have to type them in with a colon every time, especially

while I am developing the form for the first time.
 
K

Ken Slovak - [MVP - Outlook]

Using possible values would one-off the form if you do that on the fly at

runtime. Check at www.outlookcode.com and search on "possible values" for

possible problems.

I'd use code to access the Excel data and then just fill the dropdown list

with those values, also using code, in the Item_Open() event handler.

"Wiggins" <Wiggins> wrote in message

news:7348172A-946E-4F57-A44D-64C79DC0BEC4@microsoft.com...
> Is there an easy way to create a list of values in excel and then link to
> this list in the dropdown box "Possible Values" in an Outlook form? I have
> one dropdown box that will have many values and may change from time to
> time
> so I don't want to have to type them in with a colon every time,
> especially
> while I am developing the form for the first time.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
P Run Time Error 91 when linking contact to task in VBA Outlook VBA and Custom Forms 1
Travis Lloyd Linking Outlook 2016 Desktop To POP3 Acc't On Android Phone Using Outlook.com accounts in Outlook 2
M Linking Excel Cell to Shared Contacts Outlook VBA and Custom Forms 7
B Can't expose sender email address when linking outlook to access Using Outlook 3
Andrew Hawkins Linking tasks Using Outlook 1
N linking an already sent/rec'd email to contact record like it did in 2000 Using Outlook 0
C Linking e-mails BCM (Business Contact Manager) 1
K Need help concerning emails linking to BCM. BCM (Business Contact Manager) 0
P Linking email responses to initial email sent Using Outlook 5
J Linking Contacts to a Message Where the Contact isn't an Addressee Using Outlook 1
J Custom Contacts: Linking button to website Using Outlook 4
M Custom Contact form queries (date control & contact/calender linking) Using Outlook 1
R Can't use "manage linking and tracking" BCM (Business Contact Manager) 10
M Outlook 2010 - linking appointments to contact activities Outlook Wishlist 9
K add an email to a business contact without linking/tracking sender BCM (Business Contact Manager) 0
K add an email to an account without linking and tracking the email address BCM (Business Contact Manager) 0
B Linking from Excel to public outlook 2010 calendar. Using Outlook 0
H Not all Email folders appearing in Manage E-mail Auto-linking BCM (Business Contact Manager) 1
G Linking Outlook to Access for Contacts in Access Outlook VBA and Custom Forms 3
S Sharing BCM contacts and linking items to records BCM (Business Contact Manager) 1
K Linking Information from Accounts to Business Contacts Manager BCM (Business Contact Manager) 1
L Linking a Business Contact to multiple Accounts? BCM (Business Contact Manager) 2
M linking projects and tasks data to access or excel BCM (Business Contact Manager) 1
K Auto-linking emails by default shared DB BCM 2007 on SQL 2008 BCM (Business Contact Manager) 4
L Out of memory errors and Auto-linking hangs BCM (Business Contact Manager) 2
Z Outlook Custom Form: Adding Dropdown(Project Code) at the end of subject Outlook VBA and Custom Forms 0
Z Adding dropdown list using custom form Outlook VBA and Custom Forms 7
T Source of Outlook 2016 Address field dropdown "Other Suggestions" Using Outlook 3
GregS Dropdown address list missing Using Outlook 1
S Custom form with dropdown Using Outlook 0
D dropdown list in new email in subject line Using Outlook 4
A How can I populate a dropdown list? BCM (Business Contact Manager) 4
witzker Abhängige Dropdown Felder in Outlook Formular Outlook VBA and Custom Forms 2
G Dropdown List Using Outlook 1
J How to create a user defined dropdown list field for a custom contact form Using Outlook 3
C Tasks > Field Chooser > Fields with dropdown menu (eg. Status). How to custom? Using Outlook 6
B How to remove an old program from the Tools dropdown? Using Outlook 7
O Comma Separated Values.ADR and A file error has occurred in the translator Using Outlook 5
A Add attachments to appointment based on field values Outlook VBA and Custom Forms 0
Diane Poremsky Could not complete the operation. One or more parameter values are not valid. New Slipstick.com Articles 0
T What code to use to move the custom field values to message body when sending e-mail ? Outlook VBA and Custom Forms 8
N How to retrieve user defined fields values to bcm form. Using Outlook 2
D Multiple values for a field (like categories) Outlook VBA and Custom Forms 1
M Make 2 independent Subs use shared Data Values Using Outlook 3
S Populate textbox values from one form to another form. Using Outlook 0
M Default values for contacts Using Outlook 8
G Displaying value of task subject field as values from two custom fields Using Outlook 4
B Passing values from custom form into another form's text box Outlook VBA and Custom Forms 1
M Assigning Values to Contact UserProperties Outlook VBA and Custom Forms 1
J User defined fields with pre-defined values Outlook VBA and Custom Forms 3

Similar threads

Top