Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to Add Combo Box to a Worksheet of Excel?

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-01-2010
Member
 
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."
Reply With Quote
  #2  
Old 06-01-2010
Member
 
Join Date: May 2008
Posts: 3,312
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.
Reply With Quote
  #3  
Old 06-01-2010
Member
 
Join Date: Jan 2008
Posts: 3,750
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.
Reply With Quote
  #4  
Old 06-01-2010
Member
 
Join Date: May 2008
Posts: 4,565
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.
Reply With Quote
  #5  
Old 06-01-2010
Member
 
Join Date: Apr 2008
Posts: 4,641
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.
Reply With Quote
  #6  
Old 06-01-2010
Member
 
Join Date: May 2008
Posts: 4,828
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Add Combo Box to a Worksheet of Excel?"
Thread Thread Starter Forum Replies Last Post
How to fullscreen Excel Worksheet Calverta MS Office Support 5 27-01-2012 07:12 PM
Clicking on Worksheet on multiple Worksheets in the single Excel file not allow viewing the worksheet in Microsoft Excel 2010 Dipanwita Windows Software 8 04-12-2011 11:24 AM
Features of Excel Worksheet Separator Mumtaz86 Windows Software 5 20-01-2010 02:51 AM
Excel opens but not the worksheet! Rob Dizzle Windows Software 5 12-01-2010 04:21 PM
How to calculate GPA in Excel worksheet Lambard Windows Software 3 06-06-2009 10:29 PM


All times are GMT +5.5. The time now is 03:26 PM.