Let’s clear up a couple things that will help us understand why .
NET prevents us from doing what seems like a reasonable default functionality, and then we’ll show one way to workaround this limitation.
By setting the Display Member and Value Member combobox properties, the application can define which Data Table column contains descriptions to display and which column contains a corresponding identifier to return to the Data Grid control.
Sometimes it is necessary to have a multi column in-cell combobox where end-user will be able to edit and select referenced data.
This makes it easier for users to quickly find existing records without having to type a value into the Find dialog box.The Data Grid Column Style contains combobox for a Data Grid on your . It is not just a dropdown combobox, which appears when a datagrid cell becomes the current cell. Net Data Grid Data Grid Column Style combobox control has the following attractive features: This combobox Data Grid Column Style automatically fills the text at the cursor with the value of its dropdown values list. As characters are typed, the component finds the closest matching item from the list and automatically fills in the remaining characters. Empty End With ' Set datagrid Memo Column Style for Comments field . Firstly, you need to insert a Command Button into the worksheet as below screenshot shown.2.Right click the command button, then click View Code from the right-clicking menu. In the popping up Microsoft Visual Basic for Applications window, replace the original code in the Code window with the below VBA code.VBA 2: Auto copy combo box value to active cell The below VBA code can help you automatically update the active cell while selecting values in a Combo Box. Make sure the Design Mode is turned on under the Developer tab.2.