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
Replies (3)
Please login or register to join the discussion.
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
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