Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling a ComoboBox with Values on a different Worksheet
I am trying to populate a combobox's listfillrange with cells on a
different sheet e.g. ComboBox1.ListFillRange = Worksheets ("SheetXYZ").Range("AB100:AB200") this gives me Run-Time error '1004" Application-Defined or Object-Defined Error I Tried to use some examples from this NewsGroup but they still give back errors -------------------------------------------------------------------------------------------------------- ComboBox1.List = Worksheets("Sheet1").Range("A1:A10").Value or ComboBox1.RowSource = "Sheet1!A1:A10" or Dim cell As Range For Each cell In Worksheets("Sheet1").Range("A1:A10") ComboBox1.AddItem cell.Value Next cell For more info on comboboxes/listboxes see www.rubbershoe.com/listbox.htm Is there a way to do this so I do not have to have cells on every sheet to be the references for filling combobox's. I am trying to keep my filesize from exploding as the amount of sheets is very large. Thanks in Advance Dave Barans |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling In A Column With Incrementing Values ? | New Users to Excel | |||
Filling in worksheet cell references | Excel Discussion (Misc queries) | |||
Filling in a table with changing range values | Excel Discussion (Misc queries) | |||
Filling values in a grid | Excel Worksheet Functions | |||
Filling Source Data Array with Decimal Values | Charts and Charting in Excel |