Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use named range to fill Userform combobox XL2003?
I must be missing something simple- I couldn't get this working, even after
googling old posts to see if I was missing something... XL2003 Userform1, ComboBox1 named range = Prescreeninglist (a variable size range based on worksheet contents) All I want is to have Combobox1 fill from the named range (no match required). Matchrequired =False, and I try to set my RowSource property =Prescreeninglist, but I get an error in the VBE saying 'invalid property value' Do I need to add the workbook name (which will change) as part of the range reference? e.g. something like ='myWorkbook.xls'!Prescreeninglist (which I tried variations of without success) or is there some other thing I'm missing? Many thanks, Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating Userform ComboBox with worksheet names in XL2003 | Excel Programming | |||
Dynamically assign ComboBox.List from named range areas | Excel Programming | |||
Combobox and named range as source | Excel Programming | |||
Fill combobox from specified range | Excel Programming | |||
ComboBox List Fill Range | Excel Programming |