View Single Post
 
Old 05-31-2016, 10:17 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,164
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You can use a macro to allow the user to add an entry to the dropbox. An example would be
Code:
Private Sub Document_ContentControlOnExit(ByVal aCC As ContentControl, Cancel As Boolean)
  Dim sName As String
  If aCC.Range.Text = "Add another..." Then
    sName = InputBox("What name do you want to add?")
      aCC.DropdownListEntries.Add sName
    aCC.Range.Text = sName
  End If
End Sub
Where is the address information going to come from? If there is a data store somewhere that can be read by a macro then you could populate the address automatically but we would need to know where that information is going to come from.

A return in vbaspeak is usually vbCr instead of ^p
aString = "some text" & vbCr & "some more text"
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote