List box in Excel 2007
I am trying to create a list box in Excel 2007. I can draw one successfully, but when I right-click and select "Format Control", I do not have the dialog box "Control" available - so I can't specify the input range and cell link. All the other tabs under the Format Control command (Size, Protection, Properties, Web) are there, just not the "Control" tab. Help please!
Alan B
Properties
Alan
Have you tried clicking on "Properties"? You can do all you want in there.
Regards
Elliott
List box in Excel 2007
Please follow the following steps:
Display the DEVELOPER tab: (If not available, click on MS OFFICE BUTTON > EXCEL OPTIONS > > POPULAR CATEGORY > SHOW DEVELOPPER TAB IN THE RIBBON > OK)
Click on DEVELOPAR > In the Controls Group click on PROPERTIES >
IN THE INPUT RANGE box enter a cell reference to a range that contains value in the list box,
In the CELL LINK box, enter a cell reference that contains the list box selection
Under SELECTION TYPE, specify how items can be selected in the list box by doing one of the following:
> to create a single selection list box click single
> to create a multiple - selection list box, click multi (I think you need to select this one)
> to create an extended - selection list box, click Extend
Please follow these steps to solve your query. Thanks, Firoz
Range for ListBox Control
Hi Alan,
When I draw a FORM CONTROL ListBox in Excel2007, I DO get the Control tab when I right-click on the control and select Format Control. I tried and was successful in specifying a range to populate the ListBox. However, when I insert an ActiveX ListBox, that tab is conspicuously absent. Is this possibly what you've done - created an ActiveX ListBox when you want a Form Control box?
Bill