Hi Smitha,
MS Excel: Creating a combo box in Excel 2003/XP/2000/97 ------------------------------ Question: I'm trying to create pull down boxes in Excel 2003/XP/2000/97 with selections to highlight and fill in the cell. How do I do that? Answer: To create a combo box in Excel, the first thing that you need to do is display the Forms toolbar. To do this, under the View menu, select Toolbars > Forms. The Forms toolbar should now appear. Select the combo box icon. Then left-click on the spreadsheet where you'd like the combo box object to appear and drag the mouse pointer to the right until the combo box is the desired size. If you are using excel 2007+ vesion, Pls follow below steps 1. Goto Excel Option->Click Developer Tab->Ok 2. Goto Developer-Insert-*Form/Active X controls* and select Combobox. xcel 2010 and Excel 2007 users. Click on Insert from the Developer tab and then click on Combo Box in the ActiveX Controls section. [image: Create an Excel VBA Combobox in Excel 2010 or Excel 2007] Excel 2003 users. Click on Combo Box from the Control ToolBox. [image: Create an Excel VBA Combobox in Excel 2003] 1. Draw a combobox on your worksheet. [image: Draw a Combobox on your Worksheet] Add items to Combobox To add some items to the combobox, execute the following steps. 1. Add the following code lines to the Workbook Open event<http://www.excel-vba-easy.com/vba-programming-event-excel-vba.html#workbook-event>(or add them to your own code). With Sheet1.ComboBox1 .AddItem "Paris" .AddItem "New York" .AddItem "London" End With Note: use Sheet2 if your combobox is located on the second worksheet. Result: [image: Add Code to the Workbook Open Event] 2. To link a cell to the combobox, right click on the combobox (make sure design mode is selected) and click on Properties. Fill in E2 for LinkedCell. [image: Combobox LinkedCell] Note: also see the ListFillRange property, to fill a combobox with a range of cells. 3. Close Excel and reopen your Excel file. 4. Choose an item from the combobox or fill in your own choice. Result: [image: Excel VBA Combobox Result] -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 29, 2012 at 2:01 PM, Smitha S R <sperdwo...@gmail.com> wrote: > How we can place a combo box in excel work sheet? > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
