| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Set ListFillRange to Another Sheet
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Set ListFillRange to Another Sheet
Doug,
Just precede the range by the sheet name as you would in a worksheet formula, DRRecipient.ListFillRange = "'sheet name'!A1:A20" -- HTH Bob Phillips "Chaplain Doug" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Set ListFillRange to Another Sheet
Dear Bob, et al:
Thank you for the help. It is obvious now, but it has been a while since I have been into my code and Excel. Thanks for the prompt reply. God bless. "Bob Phillips" wrote: Doug, Just precede the range by the sheet name as you would in a worksheet formula, DRRecipient.ListFillRange = "'sheet name'!A1:A20" -- HTH Bob Phillips "Chaplain Doug" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ComboBox ListFillRange | Excel Discussion (Misc queries) | |||
| Combo box - Listfillrange | Excel Discussion (Misc queries) | |||
| I can't figure out listfillrange | Excel Programming | |||
| ListFillRange | Excel Programming | |||
| ListFillRange | Excel Programming | |||
Linear Mode
