Results 1 to 6 of 6

Thread: How to Add Combo Box to a Worksheet of Excel?

  1. #1
    Join Date
    Aug 2006
    Posts
    168

    How to Add Combo Box to a Worksheet of Excel?

    I am having the Microsoft Office Excel 2007. I just want to know that how to add Combo Box to Worksheet Of Excel. I have tried a lot but I am not able to do that. I even tried to search on Google, but the results I got was not able to understand. Since they have used the high technique language and I am beginner to such thing, I expect some help in the simple language. Any suggestions would be greatly appreciable.
    "All gave some, some gave all."

  2. #2
    Join Date
    May 2008
    Posts
    3,319

    Re: How to Add Combo Box to a Worksheet of Excel?

    You can Add a Combo Box using the following steps :
    (this applies to the form control)
    1. Click the Office Button and then click on the Excel options.
    2. Under Top options for working with Excel you will find the Popular category, in that select the Show Developer tab in the Ribbon check box, and then click OK.
    3. Now on the Developer tab, click Insert which will be in Controls group and then under Form Controls, click Combo box Button image.
    4. In the Control group click the worksheet location where you want the upper-left corner of the combo box to appear.
    5. Now the drop-down arrow should be displayed with the text box collapsed.
    Hope that it will help you.

  3. #3
    Join Date
    Jan 2008
    Posts
    3,758

    Re: How to Add Combo Box to a Worksheet of Excel?

    You can also specify the control properties. Right click on the Control and then click Format control. If you want to specify the control properties, do the following :
    1. In the Input range box, enter a cell reference having a range that contains the values that you want to display in the drop-down list of the combo box.
    2. And in the Cell link box, enter the cell reference containing the selection in the drop-down list of the combo box.

  4. #4
    Join Date
    May 2008
    Posts
    4,574

    Re: How to Add Combo Box to a Worksheet of Excel?

    You can enter the number of lines to display in the drop-down list of the combo box in the In the Drop-down lines box. The following are the values associated with the drop-down list of the combo box :
    • 0, it is ignored totally and treated as 1.
    • If the number is less than the number of items in the range specified in the Input range box, then a scroll bar is displayed.
    • If the number is equal to or greater than the number of items in the range specified in the Input range box, then no scroll bar is displayed.

  5. #5
    Join Date
    Apr 2008
    Posts
    4,644

    Re: How to Add Combo Box to a Worksheet of Excel?

    You can also Add a combo box in the ActiveX control using the following steps : (you have to follow the same steps till you click Combo box Button)
    • Then click on the worksheet location where you want the upper-left corner of the combo box to appear.
    • Now to edit the ActiveX control, you should be in the design mode.
    • You can turn on the Design Mode by going to the Developer tab, in the Controls group and turning the Design Mode Button on.
    • Then for specifying the control properties, click Properties Edit code button which will be on the Developer tab, in the Controls group.

  6. #6
    Join Date
    May 2008
    Posts
    4,834

    Re: How to Add Combo Box to a Worksheet of Excel?

    You can use the property AutoLoad (Excel) whenever you want to check whether the control is loaded when the workbook is opened. This property will be ignored for ActiveX controls. The property Locked (Form) is used to check whether the control can be edited. The property Bold, Italic, Size, StrikeThrough, Underline, Weight (Form) is used for checking the Font attributes. And the property AutoSize (Form) will help you to check the size of the control automatically adjusts to display all the contents.

Similar Threads

  1. How to fullscreen Excel Worksheet
    By Calverta in forum MS Office Support
    Replies: 5
    Last Post: 27-01-2012, 06:12 PM
  2. Replies: 8
    Last Post: 04-12-2011, 10:24 AM
  3. Features of Excel Worksheet Separator
    By Mumtaz86 in forum Windows Software
    Replies: 5
    Last Post: 20-01-2010, 01:51 AM
  4. Excel opens but not the worksheet!
    By Rob Dizzle in forum Windows Software
    Replies: 5
    Last Post: 12-01-2010, 03:21 PM
  5. How to calculate GPA in Excel worksheet
    By Lambard in forum Windows Software
    Replies: 3
    Last Post: 06-06-2009, 09:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •