As we say in Boston, "Bizaaah".
I never use the list source property. It links the form too tightly to
the sheet. Instead I load the values in the range into an array, and
assign this array to the list.
I suspect the listbox with focus has a different relationship with the
range than the listbox without focus. This difference may account for
the difference between "" and Null. Using an array instead of a range
does not have any such difference.
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
OssieMac wrote:
I don't know the answers Tim. I simply tested to see what was happening but
am at a loss to explain why. The code I posted is simply a workaround because
I know it is possible to test for null and also that you can assign a zero
length string to a variable.