View Single Post
 
Old 12-15-2014, 02:15 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,137
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

Rather than use a second userform to display the data, put a label on the main form and set the label caption to have the combined address text e.g. as follows. which will give you a visual indication of what is to be inserted. You can also insert strAddress into the document.
Code:
Dim strAddress as String
With Me.ListBox1
    strAddress = .column(0) & vbcr & .Column(1) 'etc.
End With
Me.LabelName.Caption = strAddress
__________________
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