MrExcel Publishing
Your One Stop for Excel Tips & Solutions

List Fill Range Control Box?

Posted by Rick on March 27, 2001 6:25 PM

Dave, I looked EVERYWHERE and I found the Linked Cell
box but there is no "List Fill Range" box or anything
even like it. Any Ideas? I am using Excel 97, is that
List Fill Range only in 2000 maybe?

:Hi Rick
:While in "Design Mode" (little picture of triangle
:and pencil on control toolbar) right click on the
:Combobox and select "Properties". Then put: B1 in
:the "Linked Cell" and: A1:A10 in he "ListFillRange".
:This will fill your Combobox with entries that are in
:A1:A10 and "place your selected entry in Cell B1.


Thanks Dave! I do have a question though...I was

Posted by Dave Hawley on March 27, 2001 7:28 PM

Rick, trust me it is there, as long as the Combobox is from the "Control Toolbox".

While in design mode ight click on the Combobox and select "Properties" scroll through this window until you see it. It is there! Then put: A1:A10 in it(or any range)


OzGrid Business Applications

Posted by Rick on March 27, 2001 8:21 PM

Dave, you are awesome! Thanks so much for your
help, it works great!!