.RowSource by row range
 

Howdee;
my last post (bout 2 wks go) got lost...
please, let me repost't:
..RowSource takes a string of Range (ccording
to ms) and it causes a problem:
myListBox.RowSource = .Range("A1:J1")
makes the myListBox control have just 1
item in its List: "A1"... Why?
though:
myListBox.RowSource = .Range("A1:A11")
complains the rules. Any thoughts?
I use Office XP. Has this rule different
meaning in later versions of xl? Thanks.

.RowSource by row range
 

It's a string

myListBox.RowSource = "A1:J1"
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Boba" wrote in message
...
Howdee;
my last post (bout 2 wks go) got lost...
please, let me repost't:
.RowSource takes a string of Range (ccording
to ms) and it causes a problem:
myListBox.RowSource = .Range("A1:J1")
makes the myListBox control have just 1
item in its List: "A1"... Why?
though:
myListBox.RowSource = .Range("A1:A11")
complains the rules. Any thoughts?
I use Office XP. Has this rule different
meaning in later versions of xl? Thanks.