![]() |
|
#16
|
||||
|
||||
|
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 |
|
|
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 |