Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

Listbox:how To Show Control Tab In Control Format Properties

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hi experts,

I made a listbox from the Control Toolbar. When I right click on the box and look at the Format Control I get 4 tab sheets: Size, Protection, Properties and Web.

But I miss the Control tab in which I can fill in the input range, cell link and the drop down lines.

How do I make appear the Control tab?


View Answers     

Similar Excel Tutorials

Quickly Enter the System Date in Excel - Keyboard Shortcut
You can insert the system Date by holding the Control (Ctrl) key and pressing the colon or semicolon key. (Ctrl+;) ...
Rename a Module for an Excel Macro
This Excel tip shows you how to rename a module in Excel. This is a very important thing to do when you have a larg ...
Remove Personal Information from Excel Files
How to remove all personally identifiable information from an Excel file. When a file is created in Excel, it auto ...
Create Gantt Chart in Excel Easily
Easy step-by-step guide to creating a Gantt Chart in Excel. Following these steps, it should take no more than 5 m ...

Helpful Excel Macros

Delete Only the Text from Cells
- This macro will delete all text from selected cells. This will not delete any other characters or numbers from any cell
Close a Workbook after a Time Limit is Reached
- This macro will automatically close the workbook in which it is located after that workbook has been opened for a certai
Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
- Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a great little macro that allows yo
Format Cells as Time in Excel
- This free Excel macro formats a selection of cells in the Time format in Excel. This Time number format means that inst

Similar Topics

Hi experts,

I made a listbox from the Control Toolbar. When I right click on the box and look at the Format Control I get 4 tab sheets: Size, Protection, Properties and Web.

But I miss the Control tab in which I can fill in the input range, cell link and the drop down lines.

How do I make appear the Control tab?


I add a new control from the 'insert' button of the Developer tab. When I right click the new control in the spreadsheet, I can only get 'format control' and not 'properties'. When I click the 'properties' button in the developer tab, it accesses the 'format control' and not the 'properties'.

How do I get access to the more detailed 'properties' for a newly added control as in Excel 2003? If it is from accessing the 'control toolbox', how do you do that in Excel 2007 other than from the Developer tab?

Thanks in advance,

kayakerca. . .

Last Week I asked about how to change size of print in combo boxes, and I was told to use control toolbox instead of forms as it has more options. I seem to remember using that some years ago, but when I tried this time I cannot make it relate to my listed data. Using forms is fine for me as I just create the box, highlight it, go to format control, and fill in the input range and cell link. I did go to properties in the control combo box, and saw similar input cells, but they do not seem to work?

Good evening,

I have two very basic questions:

Question 1. How do I rename a combo box in Excel 2007

I created a combo box in Excel 2007 by going to Developer > Insert Controls> ComboBox (Form Control) and then clicking and dragging to create the control on a sheet.

However, I cannot figure out what the name of the control is or how I change the name. When I right-click on the control and then choose Format Control, the only tabs are size, protection, properties, web and control (none of which seem to have the name of the ComboBox).

Question 2: Once I figure out the name of the control, how do I retrieve the currently selected value of the control in VBA. If the control name were DropDown3 would I simple do the following:

Dim val as String
val = DropDown3.Value

Any suggestions are much appreciated!


Office 2K Excel's scrollbar' format control has the following tabs:
-Web and

The control is missing in my Office 2K3 Excel. I need to set some control.
Any idea how to enable the tab? Your assistance will be highly appreciated!


I have some form controls on a worksheet (sliders/comboboxes) and what I want to do is write some generic event code using the Cell Link property for each clicked control.
Now, I know (thanks to you guys) how to get the selected control:
But what i can't figure out is if it's possible to get the properties from the 'Format Control...' options, such as the min or max value of a slider or the range set as the cell link of the combobox.
Any help/advice gratefully received.
Thanks in advance

I am starting to get good in VBA, but recently have encountered a problem. I implemented a ListBox control by inserting it using the Control Toolbox toolbar. On my laptop running Excel 2000, it inserted properly and I was able to fill the list using VBA by writing to the .ListFillRange property. I got my code working and sent it to another colleague. He encountered an error when running the code. I went to his computer, running Excel 2003, got in Design Mode and viewed the properties of the ListBox in question. ListFillRange was not listed as one of the properties! I went to another PC using Excel 2003, and the ListFillRange property was present. So, the issue is not related to the version of Excel, since two separate PCs running Excel 2003 showed different properties for a list box (one had ListFillRange, one did not). What controls what properties a control has? How can I ever be confident in writing VBA code that udpates properties of controls? Thanks for any input on this issue...

I'm writing an Excel app that is to run on PC's and Mac's.

Therefore, I need to use a Forms Control and not the ActiveX control. It seems that I have less control over the Forms control than I need. Is there a way to change the font in the Forms Listbox control?

Thanks for any info . . .

Rich W.

I have some odd behavior occuring with my UserForm.

I had inserted a ListBox into the UserForm, and I was re-positioning the control when...I don't know what finger slipped off the mouse, or something. But, the ListBox simply VANISHED!!

No problem, right?? I simply grabbed and inserted another control.
The NEW control is listed in the UserForm Properties as ListBox 2 ...!!!
ListBox 1 is NOWHERE TO BE FOUND...!!!
It's not listed in the UserForm Properties...(ListBox 2 is there).
It's not visible on the UserForm, itself...(ListBox 2 is).
I even looked in the Tab Order for the UserForm...again, ListBox 2 , but no ListBox 1 .

And get this...If I try to RENAME ListBox 2 to ListBox 1 , I get an "ambiguous name" error.

Here's why this is a problem...

I have lots of Macros or Event Procedures written to perform actions with the items found in ListBox 1 on all of my UserForms. I will have to re-write all of that code to make it work with this UserForm...

Or, I can re-build the UserForm from scratch...which is probably what I will end up doing.'s my questions:

Does anybody have any idea what happened, here??
Have you ever experienced this before??
And, if you know how to fix it without scrapping the UserForm??

I spent a while searching for the solution on the internet...and couldn't even find anyone that had experienced a similar situation.

Any insight would be greatly appreciated.

I am trying to find a way to pass an active x listbox control into a procedure to deselect its selection. I have several listboxes that a user makes multi value selections in but would like to use the same function to deselect the items of a listbox by passing in the relevant listbox control name(or whatever is needed). This works fine if I want to resize a list box ,make it visible etc but when trying to read the selected items and then deselect them I get "Object doesn't support this property or method"

Is it not possible to pass in a listbox control and use this type of functionality ? I have other similar types of functionality I would like to do with the listboxes without having to repeat the same code over again for each listbox event.


Private Sub Button1_Click()


End Sub

Private Sub ClearListBox(CtrlName As String)

Dim WS As Worksheet
Dim Control As OLEObject

Set WS = ThisWorkbook.Sheets("Filters")

Dim i As Long
For Each Control In WS.OLEObjects
If Control.Name = CtrlName Then
For i = 0 To Control.ListCount - 1
Control.Selected(i) = False
End If

Next Control

End Sub


I've added a listbox to my spreadsheet from the control toolbox. I've made it multi select and the listfillrange is linked to a set of values on another sheet in my spreadsheet. I'm having some random problems that when I scroll up and down or click on entries in the listbox sometimes it appears to vanish! It actually makes itself very small, giving the appearance it has disappeared altogether. The only way I can get it back is if I switch into design mode and tab through each control that I have in the spreadsheet then when I get to the listbox resize it back to its original size.

Just wondered if anyone else had come across this kind of behaviour with listboxes before?


ps I chose to use the control listbox as I needed to loop through in vba and get the selected values and couldn't figure out how to do that with the forms listbox (I'm more familiar with the control toolbox as have used it on user forms before).


I'm trying to add a combo box into my worksheet.

When I select the format control option I do not get the see the very necessary "control" tab so I can define the input range.

Does anyone know why the control tab under the format control window would not show up?

Any information would be greatly appreciated.

Thank you

This is my first time using a slider control, and I'm clearly missing something. From the Insert Controls box I chose "More Controls", then I chose the Microsoft Slider Control 6.0 (SP6), then I drew it onto my sheet.

From another thread I found the following code which is supposed to bind it to the cell I want it to affect:

Private Sub Slider1_Change()

Range("d9").Value = Me.Slider1.Value

End Sub

I put this code into the code section of the tab that it lives on.

However, I can't seem to get it to "activate". By that, I mean that, whenever I click on it, it just selects it. It doesn't ever let me use it as a slider. I've tried looking at Properties, the Slider Properties flyout, and Format Control. None of those seem to offer anywhere to specify the cell link.

Any help would be greatly appreciated. Thanks

I have a cell that uses a validation list to select from a large list of names from another workbook. The problem is that it takes a few minutes to load this data into the drop down menu. I would like to have a way to start typing in the last name and have the list display only those names that meet the entered criteria. If I entered 'man' the list would autofill and display all the names that started with 'man' such as Manning, Mansfield, Manchester, etc.

I have tried using and ActiveX Control box and after I enter the name of the List I used in the drop down validation field in the control box properties, I cannot access the control box field in order to begin entering data. How do I get this to work? After I set the initial properties for the first time when I create the control box, I cannot go back to the properties window to review my selections. When I right click on the control box, all I have access to is the assign macro, format box, group, align features in the menu that appears. I am running Excel 2007. Is there another/better way to accomplish this? How to I access the properties box after my initial setting of the parameters?

Thanks for the help,


I have copied a Spin Control from another workbook. It works perfectly.

When I created one from the Control Toolbox there was no Control tab when I went to Format Control.

What have I done wrong?

When I manually add an ActiveX control to a sheet I can right click on it and see or change its properties. However, when I add the same control through VBA I am unable to see its properties. Another peculiar thing I found is that the control generated is actually a group of images. Just right click on it and choose to ungroup it. You will see a lot of images.

With ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False _
    , DisplayAsIcon:=False, Left:=195, Top:=27.75, Width:=108, Height:= _
End With

I have some activex controls on a worksheet and I have noticed some odd behavior. Occasionally, the font size for these controls will change size (sometimes bigger, sometimes smaller) whenever my users click on the control. This is happening in labels, text boxes and buttons.

I've searched the net and found one useful posting that this behavior can be related to the control format properties for moving and sizing with cells. That doesn't seem to be the case here. This behavior occurs regardless of the object position settings.

Anyone have any advice, this "bug" is causing me to constantly edit the control, as the font will return to normal if I resize the control.

Issue is in Excel 2003 on Windows XP OS.


Im a beginner in VBA and i am designing a form to be used at my work. I have 2 questions.

1) i have added a combo box but cant populate the list.

I was told to do this by a friend

If your Combo is from the Forms toolbar then:

Right click on you Combo and select "Format Control" then click the "Control Tab" now put you range that contains your list in the "Input range" box.

If from the Control Toolbox:

Right click on it and select "Properties" then Scroll down to "ListFillRange" and type your range, e.g A1:A100

You may want to consider using Data>Validation with "List" as your allowed entries.

Hope this helps

but i dont have format control and in the properties list, listfillrange does not appear??? What do i do now?


2) I want to set up a txt box that automatically generates a reference number that cant be edited if the form is being filled in.

Can you help?

I had this on another thread that was closed and was told this by paul:

I mean there are two type of controls Forms and active x

active x has the format control
Forms has the properties

you need to select the active x Controls toolbox

or run this

Sub ptester()
With Sheets("1")
    Set pboxes = .Shapes.AddFormControl(xlListBox, 100, 10, 100, 10)
    pboxes.ControlFormat.ListFillRange = "A1:A10"
End With
End Sub

regards pike

But i dont have format control, i dont know how to add it and i dont know where to insert this code so it works???????

Please help!

I have a listbox control (not a "form" control) on a sheet. After updating
the ListFillRange setting, the row area of the control is not refreshed.
Paging down and back up or changing to a different sheet and back gets the
screen to refresh the area within the listbox. It happens with
ScreenUpdating on.

I have a workaround when i know the box needs to be updated - I set visible
to false and then back to true - but it also happens when a form happens to
overlap the control. When the form is closed, the portion that overlapped
the control is still visible in the control.

Another programmer I talked to had the same problem and did not know of any
better solution. Is this actually a problem with the contol itself, or am I
doing (or not doing) something that creates this problem? Is there a
solution that can keep the listbox refreshed without requiring code anytime
it might possible be affected by a form?

Slightly esoteric query; I need a combination list/combobox for a current project, much the same as the Properties control within the VBA IDE, with a list of items in the lefthand column, and combo box style dropdown/text entry in the right column.

I'd planned to do this with a listbox and a few ancillary controls, but it occured to me that, if I could find the Properties control in the additional controls menu, it might do the job that bit more neatly.

Is this possible or am I completely off track here?

I need to copy a list box control into about five hundred
cells. I need the cell link of the control, however, to
change so that it references the cell the control is
pasted into. No matter what I do, however, the cell link
of the pasted control stays the same (not surprisingly)
as in the original control. (And nope, it doesn't seem
to matter whether the cell-link reference is absolute
[including dollar signs] or not.)

If anyone has any ideas, I'd be extremely appreciative--I
really don't want to individually format 300 controls.

I cannot change the input range and cell link within the format control
option of a combo box.

Does anyone know why this control tab is missing?

Many thanks


I`m new to access vba but understand excel vba but i`m having a few problems with showing a control and a label together. I currently have a form with a few text boxes which can be visible or hidden depending on a value of a spin button.

I can get the control to hide and become visible but do i also have to add a line of code to show the control label or is there something in the properties so that when i hide or make the control visible it also show/hides the label.

Cheers for any help


I have a workbook that was developed in a prior version of Excel, by someone else. I am now working in Excel 2007 ... and I'm *guessing* this was developed in Excel 2000. The workbook has a UserForm that contains a Combobox control (that is used as a drop-down list). While viewing the UserForm (in Designer mode), when I right click on the combobox control and choose the Properties option I see a fairly standard-looking list of properties. The only thing is ... I don't see the LinkedCell and ListFillRange properties I expect (which I DO see if I create a brand new workbook and add a new UserForm containing a ComboBox control). I need to change the range used to populate the combobox, but since I don't see those properties I cannot do it in the Property Inspector. I suppose I could change the values via VBA code ... but I would rather not (at least, not until I am able to find and see the current properties). I DO see a RowSource property in the Inspector ... but it is empty. Clearly the values are being set at some point because there are values in the drop-down listbox when the control is displayed at run-time. But searching the entire Project I find no references to either "linked" or "rowsource" or "listfill" so I don't think its being set via VBA code.

It seems those properties are "missing" because because of the Excel version differences (since I can see the LinkedCell and ListFillRange properties if I create a new workbook / control). Any idea how to get them back onto the list so I can see them via the Property Inspector?


Parry - or anybody else
I did search - found this - Can you tell me how to insert i.e. a Listbox right onto the worksheet - using code. I would like to see it both as a Form control as well as an ActiveX control - I like the Form control as it has the OnAction property - that allow me to add the control at run time and have the event code in my module. However I like working with ActiveX better. So if the control and be ActiveX and the event flag for that control resides in a module - that would be perfect. Hope you can help