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 |
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 |
All times are GMT +1. The time now is 09:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com