Thread: How to Set ListFillRange to Another Sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
  
Posts: 1,758
Default How to Set ListFillRange to Another Sheet
DRRecipient.ListFillRange _
= ThisWorkbook.worksheets("setup").range("aa1:ab365" ).address(external:=true)

(activeworkbook instead of ThisWorkbook????)



Chaplain Doug wrote:

Excel 2003. How do I programatically set the ListFillRange of a combobox
control to a range of cells in another sheet in the same workbook?

DRRecipient.ListFillRange = ?

The other sheet name is "Setup" and the range I want in "Setup" is
"AA1:AB365" Thanks.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

--

Dave Peterson
Reply With QuoteReply With Quote