Select a macro in the list and press ok! Code 1: The below code is useful to select blank option in list box. Excel VBA Assign In the Properties for the ComboBox click into Rowsource and add the name for the named range that you created earlier “Products” Adding the VBA code to the Userform. Filter an Excel Applies to: All desktop versions of Excel for Windows. Form Controls are used for both manual data and macros. To set a cell value, you need to use the “Value” property, and then you need to define the value that you want to set. Click on the New button. Get the full course: https://courses.xelplus.com/p/professional-excel-dashboardsFind out how you can insert and use the combo box form control in Excel. Press with left mouse button on "Insert" button. You can assign a command button to automate the macro or some calculation of formulas. Press with left mouse button on "Developer" tab. Recommended Articles. Assume that you have already written or recorded a Macro called Macro1. 2. Show a welcome message to the user I will use the form that I created for How to Add Items from File Dialog to Listbox and add a Clear List button. How to handle this error? 2. Run a Macro Automatically – Example Cases: Following are the list of situations where we need to run a macro automatically on opening an excel workbook. If you want to see the Macro function, you can click on three dots (…) behind the [Embedded Macro] to open the set of command inside the Embedded Macro as shown below. Download Visual Studio 2005 Retired documentation from ... Row Source in Userform Combo Box Press with right mouse button on on your new button. For all other choices call the HideChart routine. ElseIf Sheet1.Range("A1").Value 5 Then Debug.Print "value is less than five." Here, this application is working perfectly. Excel Double click inside the Userform and then copy the code below and paste into the Visual Basic editor. If the Project Explorer is not visible, click View, Project Explorer. The Assign Macro dialog will pop up. For example, you can write a macro to format a spreadsheet in a particular way. Right-click on the rectangle border, and choose 'Assign Macro' Click the New button Last month's article, "Pro tip: Add a UserForm to aid data entry in Excel," shares the basics of creating an Excel UserForm using VBA to populate list … Select the macro you want to assign to the button. Task : Filter data based on column A values listed in drop down. Copy and Paste a Row from One Sheet to Another. Form Controls can also be used with charts. VBA ListBox Default Values in Excel. Update Excel Slicers with Macro. Hye!somebody can help me how to solve this issue. The Assign Macro Dialog Box will pop up and you will want to find & select your macro's name (in this case "Searchbox"). Use the WriteHello macro that we put in our VBE. Press and hold and then drag with mouse on sheet. Note: If the Combo Box does not contain any sheet name in your worksheet, please follow the below tip to quickly add all sheet names to that Combo Box.And if there is already a Combo Box containing all sheet names, please shift to the step 1 … Form controls are the Excel original controls that are compatible with earlier versions of Excel, starting with Excel version 5.0. How to Clear Items from Listbox In this How To, I will show how to clear items from a listbox. Else Debug.Print "value is equal to five." The Userform we are going to create looks as follows: To create this Userform, execute the following steps. ; Set Cell Value. Excel Hi Doug, I have been doing that and for some reason I do not see any sort of assign macro options in the field properties. If the macro starts by moving the active cell two cells down, the macro will include these commands in the code. For example the .ListIndex property returned if the first item in … Rename the Macro name to SortCustomerName. Form controls are the Excel original controls that are compatible with earlier versions of Excel, starting with Excel version 5.0. macro Working with LIST BOXES (Form Controls) ComboBox in Excel VBA is one of most useful control in the Excel. PrintScreen) Click on New button; A Microsoft Visual Basic for Applications will open as shown below. I can then add a new record into the table and reconnect the table to the control using Ctrl.RowSource = "Clients", or Ctrl.RowSource … Re: Combo Box with Links to other sheets. Slicers were introduced in Excel 2010, and they make it easy to change multiple pivot tables with a single click. Applies to: All desktop versions of Excel for Windows. A dialog box pops up; in the dialog box, click on the cell link and then select an empty cell to link the checkbox. ; Press ALT + F11 to open VBA editor window. To run multiple macros by using a button, please do with the following steps: 1. For this example, get Excel to display the UserForm in the following 3 simple steps: Go to a module different from the UserForm's code module. Run a Macro Automatically on Opening Excel Workbook – Solution(s): We can use Workbook_Open() method or Auto_Open() method to achieve this. To assign hotkey Crtl+Shift+k to Macro1, we find the the code that represents “Ctrl” and “Shift” from the above tables, and below is the code we will use.. Application.Onkey "^+k", "Macro1" Live Data Transfer from Microsoft Excel to Google Sheet. Under the Developer Menu, click on the Insert icon. Rows (and columns in multi-column) listboxes are indexed starting with 0. Add text to the shape (Right-click > Edit Text | or double-click in the shape). This super simple macro will copy a row from one sheet to another. combo box in Excel On the Drawing toolbar, click on the Rectangle tool (In Excel 2007 / 2010, use a shape from the Insert tab) In the centre of the worksheet, draw a rectangle, and format as desired. Right click on the drop down and select Format Control and then go to Control tab; In the Input range: enter A2:A6 (values to display in the drop-down list). Under this dropdown combo box, you will see 4 sets of commends under the Embedded Macro: 1. Select a macro to assign. Combo Box:Combo Box control is used to display a drop-down list of items. The ID ' field is your BouondColumn, the concatenated last/first names The Webinar. Drag and place the button on Excel sheet. Excel VBA Macro to Copy an Excel Range as Picture and Pasting as Picture Sub Copy_Paste_As_Picture() 'Method -I : Copying the Range a... How to remove a Carriage Return Line Feed (CRLF) from a String of Varchar Column in SQL Server Press with right mouse button on on your new button. Create a combo box on form. The Assign Macro window will open. Multiple Column ComboBox. The syntax of this event is this. Press with left mouse button on and drag on your worksheet to create the button. Thanks for helping me out , but yea the combo boxes are on a VBA User Form. In the Properties for the ComboBox click into Rowsource and add the name for the named range that you created earlier “Products” Adding the VBA code to the Userform. Drag a combo box on your worksheet. c. Before running a macro with relative cell addresses, it does not matter where you set the active cell. This Excel VBA example shows how to restrict a combo box in a UserForm, so only items that match a list can be entered. Re: Fill ComboBox With Cell Range & Link ComboBox To Cell. Step 1. 3) Right-click the worksheet tab and select View Code. You can refer to a cell using Cells and Range Object to set a cell value (to Get and Change also). I discussed different techniques of implementing a multi-select input feature in Excel. To avoid this, I'm using the command Ctrl.RowSource = "" to disconnect the table from the control. Single Column ComboBox. Excel has proven not to be able to do this correctly. Live Data Transfer from Microsoft Excel to Google Sheet. If you do not see Developer in that column, select All Tabs from the Choose commands from drop down. A combobox can be configured to accept pre-defined list entries only or allow the user to enter his or her own text. How to Assign a Macro to a Cell in Excel By Stephanie Ellen Techwalla may earn compensation through affiliate links in this story. To create a combo box in Excel VBA, execute the following steps. the Assign Macro window will open; You can change the Macro name (Ex. You can assign an existing macro to a control, or write or record a new macro. Right click on the Button and select Assign Macro. With g_rst .MoveFirst Do Until .EOF ' The semi-colon in the string indicates a column break. Fixed issue where the credentials wouldn't be resolved in the after open Typing Macro event; Fixed issue where the typing macro of the "Events" tab of an entry wouldn't be usable if it was a "Linked" typing macro; Fixed issue with "force show navigation pane on startup" option not working Once you have highlighted your macro name and clicked OK, every time you click your search button your filtering macro will run. Click on Options. You can assign an existing macro to a control, or write or record a new macro. Task : Filter data based on column A values listed in drop down. To run macro as the workbook closes we will use Workbook Event Workbook_BeforeClose. Yes, I have saved it as .xlsm but there is no option to "add macro" when I right-press with mouse over the command button. I discussed different techniques of implementing a multi-select input feature in Excel. I can assign a macro to the combobox, but I have 12 macros and 12 values in the combobox - each one must be assigned independantly The only thing that I can get to work is one macro (one of the 12) And no matter which value I click on it just uses the one macro Link the comobox to a cell, the selected index then goes in that cell. 2. Press with left mouse button on "Insert" button. Press with left mouse button on "Developer" tab. End If. PrintScreen) Click on New button; A Microsoft Visual Basic for Applications will open as shown below. Draw a shape on the sheet (Insert tab > Shapes drop-down > Rectangle shape). So, our application is ready. This subroutine does the same thing, it assigns a macro named "Macro1" to "Combo box 1" on sheet 1. A combobox / listbox and some other. Press with left mouse button on "Insert" button. Select the macro you want to assign to the button. The Assign Macro dialog will pop up. First, insert a button by clicking Developer > Insert > Button (Form Control), see screenshot: 2. The button will then be in Edit mode. Assign Macro. How to Clear Items from Listbox In this How To, I will show how to clear items from a listbox. Excel VBA ComboBox Match Required. The following code shows a simple example of using the VBA If statement. Drag and place the button on Excel sheet. Run a Macro Automatically on Opening Excel Workbook – Solution(s): We can use Workbook_Open() method or Auto_Open() method to achieve this. In the ActiveX Controls group, click Combo Box. The next option for sorting drop down lists uses a free Excel … Form controls are also designed for use on XLM macro sheets. Select a macro to assign. A combobox / listbox and some other. 1. ; Press ALT + F11 to open VBA editor window. Right click on the drop down and select Format Control and then go to Control tab; In the Input range: enter A2:A6 (values to display in the drop-down list). I will use the form that I created for How to Add Items from File Dialog to Listbox and add a Clear List button. How to Sort Drop Down Lists Automatically in Excel - … Excel Details: Anyone using a desktop version of Excel on either Windows or Mac should be able to use a macro to automatically sort their drop downs. You can assign a macro to a combobox by press with right mouse button oning on the combobox and select "Assign Macro". End If. In the column on the right under Customize the Ribbon, make sure to select the checkbox for Developer. Get the free workbook, to test the macro. The VB code will be saved under the Module that can be used on any sheet under this workbook; Step 2. VBA ComboBox Excel Macros Examples Codes for Adding new Items,Adding new Items to another ComboBox based on selection of first ComboBox ,Clearing Tutorials. Note: you can change the name of a control by right clicking on the control (make sure Design Mode is selected) and then clicking on Properties. Combo Box:Combo Box control is used to display a drop-down list of items. Questions: 1. Exit VBE and return to Excel. ' Configure combobox properties With cboRecordset .RowSourceType = "Value List" .BoundColumn = 1 .ColumnCount = 2 .ColumnWidths = "0;1in" End With ' Load combo box with recordset values. The below VBA code can help you to go to a specific worksheet based on the Combo Box selection in Excel. Date format in an Excel VBA ComboBox or ListBox. Or, enter the list's range name in the combo box properties, as described on the Excel VBA ComboBox Match page. ; In the Cell link:, enter D1 (cell reference that tells you which value is selected in the drop-down list). Sub Add_Dynamic_ComboBox() 'Add Dynamic Combo Box and assign it to object 'CmbBx' Set CmbBx = UserForm3.Controls.Add("Forms.comboBox.1") 'Combo Box Position CmbBx.Left = 20 CmbBx.Top = 10 End Sub Now, click F5 to run the macro, click ‘Create_ComboBox ’ … Procedure – Name of the Macro (Sub Procedure). b. An Excel macro is simply a series of instructions.After you’ve created a macro, Excel will execute those instructions, step-by-step, on any data that you give it. Assign the macro (Right-click the border of the shape > Assign Macro…) Select the macro from the list. Create a List Box. Right-click on the rectangle border, and choose 'Assign Macro' Click the New button Input Range is your data source for combo box. You can run macros by using Form controls. Exit VBE and return to Excel. With the rectangle selected, type: Click here to add Part Information. The for combobox option 4 call the DisplayChart routine. In the Developer Tab of the ribbon, simply click on Button (in Windows, click on Insert, and then under Form Controls, click on Button) Then click on the Worksheet to add the button. Press OK. Excel VBA : Filter data based on drop down selection Deepanshu Bhalla 8 Comments Excel Macro, VBA. If Sheet1.Range("A1").Value > 5 Then Debug.Print "Value is greater than five." After adding items to list box by using any of the below code you can define the default value. Let's go through each of these steps: Step #1: Go To A Module You can build a List Box with vba code, here is how: Combined with the combobox it can cause Excel to blackout, because any change in the combobox will be transferred directly to the 'source'. This is a guide to Form Controls in Excel. Add item to List Box: 2. Introduction. If the macro starts by moving the active cell two cells down, the macro will include these commands in the code. Sorting Drop Down Lists with the List Search Add-in. How to Sort Drop Down Lists Automatically in Excel - … Excel Details: Anyone using a desktop version of Excel on either Windows or Mac should be able to use a macro to automatically sort their drop downs. 2. Run a Macro Automatically – Example Cases: Following are the list of situations where we need to run a macro automatically on opening an excel workbook. Getting the combo box to update when the list updates requires a bit more work. Else Debug.Print "value is equal to five." On the Drawing toolbar, click on the Rectangle tool (In Excel 2007 / 2010, use a shape from the Insert tab) In the centre of the worksheet, draw a rectangle, and format as desired. home > topics > microsoft access / vba > questions > how to assign values in combo box Post your question to a community of 469,711 developers. cboCategoryName = Me. Let’s open the Form and Google Sheet simultaneously in the same screen to test this automated Data Entry Form. George, 1) Create the ComboBox on your worksheet. 1. This will allow you to use the Name Box, next to the formula bar, to set the name of the chart to MyChart. Set a select user from the list as a temp CurrentUserID 2. To write in a workbook event do this. 1. Many web browsers, such as Internet Explorer 9, include a … For this example, get Excel to display the UserForm in the following 3 simple steps: Go to a module different from the UserForm's code module. From the Procedure dropdown, at the top right, choose Initialize Enter the following code. Create a Sub procedure that calls the Show method of the UserForm object. Right click on the Button and select Assign Macro. In the VBE, select the UserForm, and choose View | Code. If the Combobox has just one record on its list How to turn this record showup? Assign Macro. Below you will find a list of basic macro examples for common Excel automation tasks. the Assign Macro window will open; You can change the Macro name (Ex. Here is a sample of the code: With cboWinLoss.AddItem "Won".AddItem "Lost" End With Basically, I want the user to just select either "won" or "lost" ( I don't want them to enter other things in that field instead), because at the moment the combo box works, but if I type in "AAA" for example, … Create a Sub procedure that calls the Show method of the UserForm object. 2. On this page are a few tips on how you can control the format. Go to the File tab. Create a button (Form Control). Here is the VBA list box default values in Excel. Right Click on the drop down and click Assign Macro and select FilterData and then click OK. Add Clear List button Under the Design Menu, click a Command button icon then place it below the Add File button Rename a button caption as … The next option for sorting drop down lists uses a free Excel … If you close the VBA it gives a warning and OK it, U will see the form has opened with its new CustomerID automatically! When the Excel Options dialog box opens, click on Customize Ribbon. For ex:- I have different streams in a college like Engineering, Medical, Arts etc. 2) Right-click the ComboBox, select Properties and set the ListFillRange property to 'Sheet1!A1:A2' (or whatever). I have create a order database and I want to use a comand button and assign a marco.after assingn the macro the command button will link to the userform or any tab by clicking the command button..need to searching by Purchase order number..I … The Webinar. d. The macro executes commands relative to the starting cell. Get Excel file. Sub Paste_OneRow() 'Copy and Paste Row Sheets("sheet1").Range("1:1").Copy Sheets("sheet2").Range("1:1") Application.CutCopyMode = False End Sub Form controls are also designed for use on XLM macro sheets. d. The macro executes commands relative to the starting cell. Sub Paste_OneRow() 'Copy and Paste Row Sheets("sheet1").Range("1:1").Copy Sheets("sheet2").Range("1:1") Application.CutCopyMode = False End Sub Here is the code for the Userform. Please do as follows. You can assign a command button to automate the macro or some calculation of formulas. The Assign Macro Dialog Box will pop up and you will want to find & select your macro's name (in this case "Searchbox"). Step 1. Open VBE using Alt+F11. Enter VB code. See details in the next section, for How the Code Works. Below you will find a list of basic macro examples for common Excel automation tasks. 8. Populating a userform combo box with a static list takes a little knowledge and some VBA code. I can add the macro in VBA but it's like I … Where ‘-1’ is the index number. Many web browsers, such as Internet Explorer 9, include a … The ComboBox Rowsource Property. You can use programming to control the slicers, and this page has sample code that you can use. Sub Add_Dynamic_ComboBox() 'Add Dynamic Combo Box and assign it to object 'CmbBx' Set CmbBx = UserForm3.Controls.Add("Forms.comboBox.1") 'Combo Box Position CmbBx.Left = 20 CmbBx.Top = 10 End Sub Now, click F5 to run the macro, click ‘Create_ComboBox ’ … Copy the following code Assign a keyboard shortcut to the displayUserForm macro. Then drag the mouse to draw a button on the active sheet, and in the popped out Assign Macro dialog box, click OK, and a button is inserted as following screenshot shown: Drag and place the button on the Excel sheet. It's quick & easy. Below we will look at a program in Excel VBA which creates a Userform that contains a multicolumn combo box. Let’s open the Form and Google Sheet simultaneously in the same screen to test this automated Data Entry Form. Assign macro Testing the Form. Members of the Webinar Archives can access the webinar … Text Field, Combo List-Edit, and Combo Drop Down-Edit are customized form controls. Create a ComboBox. End Sub. Create a button (Form Control). ; In the Cell link:, enter D1 (cell reference that tells you which value is selected in the drop-down list). Visual Basic for Applications (VBA) code is required to make the combo box appear when you double-click in a cell that contains a data validation list. Having dates in a ComboBox or ListBox in Excel VBA can be a real teaser, because VBA changes the date format, and that may not be the way you want the dates displayed. Assign macro Testing the Form. 3. Below are the steps: Right-click on a checkbox and click on “Format Control”. Copy and Paste a Row from One Sheet to Another. And at the programming is a small advantage in the use of the ComboBox, because it allows the direct use of the list's value. 2. If you use 'rowsource' you make a direct link to a certain range in a worksheet. Macro1 is rund as soon as the selected value in the combo box is changed. I have an excel sheet with columns like STREAM,COURSE etc.. Each stream will have multiple courses and we are having hundreds of streams. What ever stream selected based on that . Box: Combo box control is used to display a drop-down list of items ' ( or )... Next section, for How to add items from File Dialog to Listbox and add a Clear list button thing... > the ComboBox Rowsource how to assign macro to combobox in excel desktop versions of Excel for Windows, Insert a button by clicking >... Vb in Excel VBA is one of most useful control in the on! Open VBA editor window ask you to Assign to the starting cell the column on the Ribbon:. Called Macro1 the Visual Basic for Applications will open as shown below choose from... Userform and Then drag with mouse on sheet 1 cell two cells,. > Go to tab `` Developer '' on the Excel sheet name ( Ex, see screenshot 2. Can help me How to turn this record showup right under Customize the,! Using cells and Range object to set a select user from the Form i. '' ).Value 5 Then Debug.Print `` value is selected in the.! Vba editor window box default Values in Excel Part < /a > Get Excel File Field, List-Edit... Is rund as soon as the selected Data to display a drop-down of... Dropdown Combo box control is used to display a drop-down list of items slicers were in... Make it easy to change multiple pivot tables with a single click Developer '' tab place button. The worksheet tab and select View code right click on the sheet ( Insert tab > Shapes >..., Combo List-Edit, and choose View | code cell ) change macro. A Sub procedure that calls the Show method of the Userform, and choose View | code select View.! To macro Excel 2013, you can write a macro a href= '' https: //bytes.com/topic/access/answers/900453-how-set-combobox-showup-its-first-value-default '' to! A single click formatted Excel tables you make a direct link to a certain Range in particular! Both ways ( you can change the macro you want to Assign it a. Code is useful to select blank option in list box by using any of Userform. We are going to create a Print button on Excel < /a > VBA... Select a button icon from the Form controls section Excel 2013, you can refer to control. Macro named `` Macro1 '' to disconnect the table from the list search Add-in selected value in the )! Run macro as the selected Data to display a drop-down list ), the... Right click on the button to set a select user from the choose commands from Drop down Data... Feature in Excel Part < /a > Get Excel File and Then the. Highlighted your macro name and clicked OK, every time you click your search button your filtering will... 2010, and Combo Drop Down-Edit are customized Form controls macro sheets open VBA window. Drag on your new button tab > Shapes drop-down > rectangle shape ) a worksheet, type click... Indexed starting with 0 macro from the procedure dropdown, at the top right, choose enter. A control, or write or record a new macro to update when the updates. > the ComboBox, select All Tabs from the choose commands from Drop down Lists the. The starting cell select user from the procedure dropdown, at the right... To avoid this, i 'm using the command Ctrl.RowSource = `` to. Display in worksheet with relative cell addresses, it assigns a macro Macro1! Box default Values in Excel VBA is one of most useful control the. Userform object click inside the Userform and Then drag with mouse on sheet ( whatever! To tab `` Developer '' tab and they make it easy to multiple... Selected in the Excel in the VBE, select All Tabs from the that! Macro that we put in our VBE a college like Engineering, Medical, Arts etc these... Properties and set the active cell two cells down, the macro (... Combobox on your worksheet to create the ComboBox, select the macro executes commands relative to starting. Example, you can write a value from a cell ) you click your search your. Drop down and they make it easy to change multiple pivot tables with a single click new button ; Microsoft! Any one item and do different operations both ways ( you can define the default value in same!:, enter D1 ( cell reference that tells you which value is than! Me How to add Part Information, click View, Project Explorer in.! List ) using cells and Range object to set a select user from the Form that created! Commends under the Module that can be used on any sheet under this workbook ; Step 2 in box. To disconnect the table from the choose commands from Drop down Lists with the rectangle selected,:! Box to update when the Excel details in the drop-down list ) add Information... One item and do different operations and select View code List-Edit, and they make it easy change! Starts by moving the active cell two cells down, the macro name ( Ex you... Row from one sheet to Another steps to build a list box button you use 'rowsource ' you a. Visual Basic for Applications will open ; you can also use slicers formatted! From Microsoft Excel to Google sheet simultaneously in the string indicates a column break by. Shapes drop-down > rectangle shape ) place the button and select View code group, click View, Explorer... Input feature in Excel VBA < /a > the ComboBox has just one record on its How. Get Excel File Developer '' on sheet 1 able to do this.... Control the slicers, and this page are a few tips on you... You have highlighted your macro name and clicked OK, every time you click search... And user can select any one item and do different operations drop-down > rectangle )... To open VBA editor window see screenshot: 2, Insert a button icon from the choose from. Drag and place the button Embedded macro: 1 and Google sheet the how to assign macro to combobox in excel from procedure. S open the Form that i created for How to Sort Data using VB in VBA... Code below and Paste into the Visual Basic for Applications will open ; you can read and write a from. Looks as follows: to create the button and select View code the Userform and Then copy the.... For Ex: - i have different streams in a worksheet adding items to box! Excel VBA ComboBox Match Required any sheet under this workbook ; Step 2 below and a! Test the macro will run you make a direct link to a control, or write record! A1 '' ).Value > 5 Then Debug.Print `` value is equal to five. ''. Set a cell value ( to Get and change also ) matter where you set the ListFillRange Property 'Sheet1... Updates requires a bit more work in that column, select Properties and set the active how to assign macro to combobox in excel! Part < /a > Go to the starting cell create looks as follows: to the... Is not visible, click on the button Insert a button by clicking Developer > Insert button. As soon as the workbook closes we will use the Form that i created for How code! '' > How to add items from File Dialog to Listbox and add a Clear list.. Option 4 call the DisplayChart routine the for ComboBox option 4 call DisplayChart... Single click one sheet to Another the free workbook, to test automated! More work `` A1 '' ).Value > 5 Then Debug.Print `` value is selected in the code Developer that.:, enter D1 ( cell reference that tells you which value is in... Cell link is where you set the active cell two cells down, the macro starts moving! Is equal to five. '' tab just one record on its list How to turn record! Add Part Information ( Form control ), see screenshot: 2 enter D1 ( cell reference that you. Will be saved under the Embedded macro: 1 workbook ; Step 2 our. The starting cell cell value ( to Get and change also ) name and OK. Until.EOF ' the semi-colon in the string indicates a column break Microsoft. Using cells and Range object to set a cell value ( to and. Paste into the Visual Basic editor ( or whatever ) list search Add-in Range is your Data source Combo! Than five. VB code will be saved under the Embedded macro: 1 not to be able to this... > ComboBox < /a > Get Excel File has proven not to be able do. Has just one record on its list How to add items from File to. The Userform object mouse on sheet ).Value 5 Then Debug.Print `` value is less than.... Be able to do this correctly to macro command Ctrl.RowSource = `` '' to disconnect the table the! //Bytes.Com/Topic/Access/Answers/900453-How-Set-Combobox-Showup-Its-First-Value-Default '' > Combo box: Combo box control is used to display in worksheet in box! Text Field, Combo List-Edit, and choose View | code shape ( Right-click the border of the code. Dropdown, at the top right, choose Initialize enter the following.. Combobox option 4 call the DisplayChart routine sheet to Another from a cell using and.