Use named range to fill Userform combobox XL2003?
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
|