Help with Invalid Use of Null Error

		Microsoft Office Forums > Microsoft Word > Word VBA
Help with Invalid Use of Null Error

FAQ

Thread Tools

Display Modes

12-15-2014, 02:15 AM

gmayor

Windows 7 64bit Help with Invalid Use of Null Error

Office 2010 32bit

Expert

Join Date: Aug 2014

Posts: 4,144

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook 2013 - Strange null password issue POP3	Nibby99	Outlook	0	11-26-2014 05:16 PM
Key incorrectly shown as invalid	Confuzzed	Office	2	10-16-2014 01:33 PM
Invalid Product Key	djclinton	Office	1	09-18-2011 09:29 AM
Eliminating zeros, null values and negatives in a column	jannie	Excel	1	06-22-2011 07:03 PM
invalid recipient	impressionsIT	Outlook	1	06-22-2011 08:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:19 PM.