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.
 
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.
< Event trigers only first two times from FromRegion. | Contact Forms Phone Numbers >
Similar threads
Thread starter Title Forum Replies Date
B Linking contact to an Appointment Using Outlook 1
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
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
L Getting Index from dropdown inserted on ribbon Outlook VBA and Custom Forms 3
R Adding Userform Dropdown List items from names of subfolders on network drive Outlook VBA and Custom Forms 10
N How to add or delete items to Move dropdown Menu Using Outlook 0
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 6
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. Using Outlook 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

Similar threads

Back
Top