Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting ListFillRange through VBA
I have a combo box called ComboBox1 on a worksheet. I want to populate
its values in VBA code. Let's say my list of values is in J2:J12. I then issue this command: ComboBox1.ListFillRange = "J2:J12", I get a "Run-time error '424'; Object required" message If I change this to: Set Worksheets(1).ComboBox1.ListFillRange = "J2:J12", I get "Run-time error '438'; Object doesn't support this property or method." Tried several other combinations, but nothing works yet. Can anyone help? Thanks. Dennis Hancy Eaton Corporation Cleveland, OH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox ListFillRange | Excel Discussion (Misc queries) | |||
How to Set ListFillRange to Another Sheet | Excel Programming | |||
Problem with setting the ListFillRange in VBA | Excel Programming | |||
ListFillRange | Excel Programming | |||
ListFillRange | Excel Programming |