Use named range to fill Userform combobox XL2003?

[Keith]

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

 

[Keith]

Ugh <slaps forehead> when that didn't work, I kept struggling until I
finally figured out that the named range had a hard-to-see syntax typo...it
wasn't a valid range, so that's the reason it kept giving me an error.
Thanks Tom and John!
Keith