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

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

"Tom Ogilvy" wrote in message
...
If doing it manually, just type in

prescreeninglist

in the box next to the rowsource property (no equal sign)


if doing it with code

me.combobox1.Rowsource = "PreScreeningList"

--
Regards,
Tom Ogilvy


"Keith" wrote:

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