If the range is A2:A150 then type that in the listfillrange (click in the
box to the right of the word listfillrange
and type it there then close the properties window)


--


Regards,


Peo Sjoblom


"sparrot" wrote in message
...
I am not sure what you mean by "Put the range with your list in the
listfillrange and the cell you want to link to" I got to that part and
am stumped.
Thanks

"Peo Sjoblom" wrote:

Office button Excel Options, make sure "Show Developer Tab" is
selected.
Click the Developer tab Controls Insert Combobox from the active x
controls,
right click the drop down and select properties, in that pane that
opens.
Put the range with your list in the
listfillrange and the cell you want to link to. Click the design mode
button
to get out
of design mode


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

"skittles_golf" wrote in message
...
How do you create a combo box in Excel 2007
--
Jenny


"Peo Sjoblom" wrote:

You can't using datavalidation, you can if you use a combobox from
the
control toolbox


--
Regards,

Peo Sjoblom



"skittles_golf" wrote in message
...
I have created several Drop Down boxes in a worksheet but I want to
make
them
visible so people know there is a drop down box there. Right now
the
arrow
doesn't show until you click on that cell. Please help I am not
quite
sure
how to format it so the drop down arrow stays.
--
Jenny