Help with Invalid Use of Null Error

gmayor · #2 12-14-2014, 11:14 PM

Frankly that won't be the only problem. While trying to decipher your code, it was apparent that you had not defined 'oRng', or 'Source' and you referred to the Userform in the userform code as e.g

Code:

UserForm1.TextBox1.Value = pStr1

rather than

Code:

Me.TextBox1.Value = pStr1

It also helps to give the userform and its elements unique names.

I am also not sure what

Code:

Me.Hide
UserForm1.Show

is trying to achieve.

The various values you have assigned to pStr1 etc are already in the list and combo boxes (assuming that part of the code works) in the hidden columns, so adding those values to the text boxes seems unnecessary? You can call them to the document directly from the list and combo boxes and make the form much simpler.

As for your original question, test whether the column has data before trying to use it and if it doesn't have a value, give it one.

Take the line

Code:

 pStr1 = .Column(0, Me.ComboBox1.ListIndex)

You could use e.g.

Code:

If Not .Column(0) = "" then
    pstr1 = .column(0)
Else
    pstr1 = " "
End if

Without the missing information the rest is guesswork.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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