LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default .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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ListBox RowSource set to range of in-active sheet - possible? What-A-Tool Excel Programming 1 December 3rd 06 12:09 AM
range name as rowsource of listbox? Stefi Excel Programming 2 January 18th 06 01:26 PM
Forms - Named Range as the RowSource Michael Beckinsale Excel Programming 4 January 11th 06 12:51 AM
Dynamic range not resized for RowSource usage Tim Zych[_8_] Excel Programming 3 August 9th 04 02:08 AM
ComboBox RowSource --- can I use a userform OWC10 spreadsheet range? Dean Frazier Excel Programming 0 February 11th 04 07:16 PM


All times are GMT +1. The time now is 06:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"