"Kendra510" wrote:
How can you do this is Excel 2003?
"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
I am considering that the learner is asking as to how can he / she get a
drop down visible in an Excel sheet column.
MS Office 2003:
Launch MS Excel 2003
Go to View - Toolbars - Control Toolbox
A tool panel shall open displaying all the control options.
Toggle to Sheet2 and key in the entries in a column which you want in
DropDown.
(Say Names of the months from A1:A12)
Select A1 to A12 - At Top Left corner where you can see A1 written - Type
Months - Press Enter Key.
Toggle back to Sheet1 and select 6th button (Combo Box) from Control Toolbox
Panel.
It will turn the mouse cursor in a hairline cross.
Draw a Drop Down Button of the length and width of your choice.
Right click on the created Drop Down Button and select Properties button.
Fill in ListFillRange as Months (This is the name you have given in Sheet2
for the A1:A12)
Close the properties dialog Box
Now in the in Control ToolBox, Press the very first button named "Exit Deign
Mode"
And there you go..... A drop Down with the name of the Months is ready for
you.
You may do experiments for Radio Buttons and other controls too.