Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-14-2013, 06:01 AM
gmaxey gmaxey is offline Help with a drop down in userform and variables Windows 7 32bit Help with a drop down in userform and variables Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,636
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Well if you are using Word 2013 and all of your users are using Word 2007 or higher then content controls (vice document variables) would, I think, be a better choice for data targets in the document.

What you need is a three column listbox contol. Put the sales rep name in column 1 (0 in control speak), the phone number in column 2 (1) and the email in column 2 (1). You can hide the contents of columns 2 and 3 (1 and 2) and only show the sales rep name in the listbox. When the user makes a selection and clicks ok then you populate the variables or content controls with the listbox column values.

Lots of methods and techniques here: http://gregmaxey.com/word_tip_pages/..._combobox.html
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help, auto select drop down by another drop down value? skrallemand Word VBA 3 09-11-2013 11:55 AM
Find and replace using variables jago25_98 Word 1 01-31-2012 04:30 AM
Help with a drop down in userform and variables Nesting Variables SET, LISTNUM, and REF Wyskers Word 1 11-13-2011 05:43 AM
changing variables in MS word - please help McGinzo Word 0 08-24-2011 06:25 AM
Envelopes with Document Variables mailtobln Word 0 02-11-2009 10:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft