View Single Post
  #25   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cajun Laura[_2_] Cajun Laura[_2_] is offline
external usenet poster
 
Posts: 1
Default How can I make a drop down box visible within a worksheet?

I was able to make the box appear using this information, but the formulas in
the others worksheets that were linked to the cell containing the data
weren't able to reference the cell once it was done this way and not through
'Data validation'.

If there is a solution that anyone is aware of (or if I just missed
something), comments are appreciated.

Thanks,

"Cajun Laura" wrote:

I have created the combo box with the instructions below. I am trying to
link the choice to populate in a cell in another worksheet in the same file
but am having trouble making that happen. Any help would be appreciated.

Thansk,

"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