Email:      Pass:    Pass?
Subscribe for Free Excel tips & more!
E-mail:
Advertisements


Free Excel Forum

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?

Thanks


Similar Excel Video Tutorials

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
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
Format Cells as a Currency in Excel Number Formatting
- This free Excel macro allows you to quickly and easily format a selection of cells in the Currency number format in Exce

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?

Thanks


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. . .


I'm using Excel w Office 2000. Until today I have had no trouble inserting
scroll bars. Usually I right click on the control bar and go to format
control. Then I go to the control tab to set parameters. The Control tab is
one of 5 tabs (size, protestion, properties, web, control). Today the control
tab has gone! How do I get it back. Thanks for your help, Chris.



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!

Thanks,
Bryan


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

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!

sokan



Hi
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:
ActiveSheet.Shapes(Application.Caller)
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
Martin


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 happened...my 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.

So...here's my questions:

Does anybody have any idea what happened, here??
Have you ever experienced this before??
And, if so...do 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.


Hi,
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.

Thanks
GJP55

Private Sub Button1_Click()

ClearListBox(listbox1.name)

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
Next
End If


Next Control

End Sub


I am trying to create a box with a drop down list, in a workbook. When I use the Control Toolbox and choose a combo box, then right click on the box, I don't get a "Control" Tab. I get a "Size", "Protection", "Properties" and "Web" Tab, but no "Control" Tab to input the location of my list and a cell link. Have I chosen the wrong type of box for this application?


Hi guys,

I am after a control similar to the Properties one in the VBE. The one where you modify properties for a control in design mode.

Does anybody know of a suitable Control that I can use in my project that has similar usage?

Kind regards,
Jordan


Hi,

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?

cheers

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).


Hello,

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,

Robert


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?


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?

also

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?


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.
Code:

With ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False _
    , DisplayAsIcon:=False, Left:=195, Top:=27.75, Width:=108, Height:= _
    24.75)
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.

Thanks!


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?

also

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
Code:

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?


Hi Everyone,

I am a fairly new VBA programmer and am having an issue where a control is no longer a control. I'm trying to figure out why it no longer is a control.

I have a worksheet with checkboxes on it from the control toolbar. I have code that runs when the user clicks the checkbox. Sometimes when the spreadsheet comes back to me from a client or associate, the checkbox is no longer a control - i.e. when I click on it, the code does not run. When I hover over it, it appears to be a picture or shape. Excel will surrond the checbox with a rectangle with the circles - as if I could drag it out to make the shape bigger.

Thanks to this forum, I have figured out how to remove the shape and add the checkboxes back into the worksheet in my VBA code. When I do that, I rename the boxes and the code once again works. My concern is why am I losing the control?

I also have another worksheet where the control is a listbox - again from the Control Toolbox. The same thing will sometimes happen with that.

In one case, I copied the information from one spreadsheet to my 'empty' spreadsheet and sent it back. That time the new spreadsheet worked fine on my associates computer.

Thanks