Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #16  
Old 09-21-2018, 08:20 PM
gmayor's Avatar
gmayor gmayor is offline Drop down options in Column A, populates column B Windows 10 Drop down options in Column A, populates column B Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

It is a bit of a faff to use the values as Paul recommends, as the dialog for inserting content controls is poor; which is why I personally preferred to do it all in VBA, which does however require more code; however what he has done is to separate the 'lines' using a pipe character, then in VBA replace the pipe character with a line break

Thus for Value he has used -

Phone: 08 1111 1111|Fax: 08 2222 2222|Email: sales@roundhousenurseries.com.au



This forum's software may screw that up by applying a hyperlink, but it should give you the idea.

Insert Content Control Add-In may be useful to you, though it does not allow the editing of Values. I may put that in a future version, but as it was written primarily to expedite work for a private client, it is not high on my todo list.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down selection which influences value in an adjacent column lyndap2 Excel 1 08-06-2018 12:08 PM
Formula to check combinations of values in one column to find match from another column kong1802 Excel 1 06-15-2018 05:26 AM
Drop down list to overlay column of cells with different formulae TomJ Excel 0 12-19-2015 08:55 AM
How can I temporarily break a 3 column format in order to type a single column paragraph William P Word 1 01-04-2015 06:40 PM
drop down menu that control filter on other column massi Excel 0 08-24-2010 01:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:58 PM.


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