View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default bound columns - listbox question

Amy,

Yes it is.; Set the columncount property of the listbox to your number of
columns, and set rowsource to the full range.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Amy" wrote in message
...
is it possible to have more than one bound column in a
listbox? I have a listbox with four columns and i'd like
to copy the value in each column of the listbox to a
seperate columns in a worksheet. can this be done?

thanks