BIMAS ISLAM BONE

<div class="MsoNormal">
Alamat : <a href="https://trumpexcel.com/excel-drop-down-list-with-search-suggestions/">https://trumpexcel.com/excel-drop-down-list-with-search-suggestions/</a><o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; vertical-align: baseline;">
<ins>Excel Drop Down list with Search Suggestion</ins><o:p></o:p></div>
<h4 style="background: white; line-height: normal; margin-top: 0cm;">
<span lang="EN-US" style="border: none windowtext 1.0pt; color: maroon; font-family: "Verdana","sans-serif"; font-size: 18.0pt; font-weight: normal; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: major-bidi; mso-border-alt: none windowtext 0cm; padding: 0cm;">Step 1 – Configuring the Search Box<o:p></o:p></h4>
<div style="background: white; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 0cm; margin-right: 0cm; margin-top: 15.0pt; vertical-align: baseline;">
In this first step, I
will use a combo-box and configure it so that when you type in it, the text is
also reflected in a cell in real time.<o:p></o:p></div>
<div style="background: white; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 0cm; margin-right: 0cm; margin-top: 15.0pt; vertical-align: baseline;">
Here are the steps to
do this:<o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l4 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
1.   Go to Developer Tab –> Insert –> ActiveX Controls –>
Combo Box (ActiveX Control).<o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l4 level2 lfo1; tab-stops: list 72.0pt; text-indent: -18.0pt; vertical-align: baseline;">
o    There is a possibility you may not find the developer tab in the
ribbon. By default, it is hidden and needs to be enabled. <a href="https://trumpexcel.com/excel-developer-tab/">Click here</a> to know how to get the
developer tab in the ribbon in Excel.<v:shapetype coordsize="21600,21600" filled="f" id="_x0000_t75" o:preferrelative="t" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f">
 <v:stroke joinstyle="miter">
 <v:formulas>
 <v:f eqn="if lineDrawn pixelLineWidth 0">
 <v:f eqn="sum @0 1 0">
 <v:f eqn="sum 0 0 @1">
 <v:f eqn="prod @2 1 2">
 <v:f eqn="prod @3 21600 pixelWidth">
 <v:f eqn="prod @3 21600 pixelHeight">
 <v:f eqn="sum @0 0 1">
 <v:f eqn="prod @6 1 2">
 <v:f eqn="prod @7 21600 pixelWidth">
 <v:f eqn="sum @8 21600 0">
 <v:f eqn="prod @7 21600 pixelHeight">
 <v:f eqn="sum @10 21600 0">
 </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas>
 <v:path gradientshapeok="t" o:connecttype="rect" o:extrusionok="f">
 <o:lock aspectratio="t" v:ext="edit">
</o:lock></v:path></v:stroke></v:shapetype><v:shape alt="Excel Drop Down list with Search Suggestions - Combo Box" id="_x0000_i1025" style="height: 168.75pt; width: 152.25pt;" type="#_x0000_t75"></v:shape><o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l4 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
2.   Move your cursor to the worksheet area and click anywhere. It
will insert a combo box.<o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l4 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
3.   Right-click on the Combo Box and select Properties.<v:shape alt="Excel Drop Down list with Search Suggestions - Combo Box Properties" id="_x0000_i1026" style="height: 165.75pt; width: 138pt;" type="#_x0000_t75"><o:p></o:p></v:shape></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l4 level1 lfo1; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
4.   In the properties dialogue box, make the following changes:<o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l4 level2 lfo1; tab-stops: list 72.0pt; text-indent: -18.0pt; vertical-align: baseline;">
o    AutoWordSelect: False<o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l4 level2 lfo1; tab-stops: list 72.0pt; text-indent: -18.0pt; vertical-align: baseline;">
o    LinkedCell: B3<o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l4 level2 lfo1; tab-stops: list 72.0pt; text-indent: -18.0pt; vertical-align: baseline;">
o    ListFillRange: DropDownList (we will create a <a href="https://trumpexcel.com/named-ranges-in-excel/">named range</a> with this name in step 2)<o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l4 level2 lfo1; tab-stops: list 72.0pt; text-indent: -18.0pt; vertical-align: baseline;">
o    MatchEntry: 2 – fmMatchEntryNone<o:p></o:p></div>
<div align="center" style="background: white; margin-bottom: .0001pt; margin: 0cm; text-align: center; vertical-align: baseline;">
<v:shape alt="Excel Drop Down list with Search Suggestions - Combobox settings" id="_x0000_i1027" style="height: 387.75pt; width: 277.5pt;" type="#_x0000_t75"></v:shape><span style="border: none windowtext 1.0pt; color: grey; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">(Cell B3 is linked to the Combo Box, which means that anything you
type in the Combo Box is entered in B3)<o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l1 level1 lfo2; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
4.   Go to Developer tab and click on Design Mode. This will enable
you to enter text in the Combo Box. Also, since cell B3 is linked to the combo
box, any text that you enter in the combo box would also be reflected in B3 in
real-time.<o:p></o:p></div>
<h4 style="background: white; line-height: normal; margin-top: 0cm;">
Step 2 – Setting the Data<o:p></o:p></h4>
<div style="background: white; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 0cm; margin-right: 0cm; margin-top: 15.0pt; vertical-align: baseline;">
Now that the search
box is all set, we need to get the data in place. The idea is that as soon as
you type anything in the search box, it shows only those items that have that
text in it.<o:p></o:p></div>
<div style="background: white; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 0cm; margin-right: 0cm; margin-top: 15.0pt; vertical-align: baseline;">
To do this, we will
use<o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l0 level1 lfo3; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
·        
Three helper columns.<o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l0 level1 lfo3; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
·        
One <a href="https://trumpexcel.com/named-ranges-in-excel/" target="_blank">dynamic
named range</a>.<o:p></o:p></div>
<h6 style="background: white; line-height: normal;">
<span lang="EN-US" style="border: none windowtext 1.0pt; color: maroon; font-family: "Verdana","sans-serif"; font-size: 12.0pt; font-weight: normal; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: major-bidi; mso-border-alt: none windowtext 0cm; padding: 0cm;">Helper
Column 1<o:p></o:p></h6>
<div style="background: white; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 0cm; margin-right: 0cm; margin-top: 15.0pt; vertical-align: baseline;">
Put the following
formula in cell F3 and drag it for the entire column (F3:F22)<o:p></o:p></div>
<div style="background: #FFFFC8; border: groove windowtext 2.25pt; mso-border-alt: three-d-engrave windowtext 2.25pt; mso-element: para-border-div; padding: 15.0pt 15.0pt 15.0pt 15.0pt;">
<pre style="background: #FFFFC8; border: none; mso-border-alt: three-d-engrave windowtext 2.25pt; mso-padding-alt: 15.0pt 15.0pt 15.0pt 15.0pt; padding: 0cm; vertical-align: baseline;">=--ISNUMBER(IFERROR(SEARCH($B$3,E3,1),""))<o:p></o:p></pre>
</div>
<div style="background: white; margin-bottom: .0001pt; margin: 0cm; vertical-align: baseline;">
<span style="border: none windowtext 1.0pt; color: #343434; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">This
formula returns 1 when the text in the Combo Box is there in the name of the
country on the left. For example, if you type <span style="border: none windowtext 1.0pt; color: blue; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">UNI<span style="border: none windowtext 1.0pt; color: #343434; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">, then only the values
for <span style="border: none windowtext 1.0pt; color: #343434; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">Uni<span style="border: none windowtext 1.0pt; color: #343434; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">ted States and <span style="border: none windowtext 1.0pt; color: #343434; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">Uni<span style="border: none windowtext 1.0pt; color: #343434; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">ted Kingdom are 1 and all the remaining values are 0.<v:shape alt="Excel Drop Down list with Search Suggestions - Helper Column 1" id="_x0000_i1028" style="height: 288.75pt; width: 122.25pt;" type="#_x0000_t75"></v:shape><o:p></o:p></div>
<h6 style="background: white; line-height: normal;">
<span lang="EN-US" style="border: none windowtext 1.0pt; color: maroon; font-family: "Verdana","sans-serif"; font-size: 12.0pt; font-weight: normal; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: major-bidi; mso-border-alt: none windowtext 0cm; padding: 0cm;">Helper
Column 2<o:p></o:p></h6>
<div style="background: white; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 0cm; margin-right: 0cm; margin-top: 15.0pt; vertical-align: baseline;">
Put the following
formula in Cell G3 and drag it for the entire column (G3:G22)<o:p></o:p></div>
<div style="background: #FFFFC8; border: groove windowtext 2.25pt; mso-border-alt: three-d-engrave windowtext 2.25pt; mso-element: para-border-div; padding: 15.0pt 15.0pt 15.0pt 15.0pt;">
<pre style="background: #FFFFC8; border: none; mso-border-alt: three-d-engrave windowtext 2.25pt; mso-padding-alt: 15.0pt 15.0pt 15.0pt 15.0pt; padding: 0cm; vertical-align: baseline;">=IF(F3=1,COUNTIF($F$3:F3,1),"") <o:p></o:p></pre>
</div>
<div style="background: white; margin-bottom: .0001pt; margin: 0cm; vertical-align: baseline;">
<span style="border: none windowtext 1.0pt; color: #343434; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">This
formula returns 1 for the first occurrence where Combo Box text matches the
country name, 2 for the second occurrence, 3 for the third and so on. For
example, if you type <span style="border: none windowtext 1.0pt; color: blue; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">UNI<span style="border: none windowtext 1.0pt; color: black; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">, G3 cell will display 1 as it matches United States, and G9 will
display 2 as it matches United Kingdom. The rest of the cells will be blank.<v:shape alt="Excel Drop Down list with Search Suggestions - Helper Column 2" id="_x0000_i1029" style="height: 291pt; width: 166.5pt;" type="#_x0000_t75"></v:shape><o:p></o:p></div>
<h6 style="background: white; line-height: normal;">
Helper
Column 3<o:p></o:p></h6>
<div style="background: white; margin-bottom: .0001pt; margin: 0cm; vertical-align: baseline;">
Put
the following formula in cell H3 and drag it for the entire column (H3:H22)<o:p></o:p></div>
<div style="background: #FFFFC8; border: groove windowtext 2.25pt; mso-border-alt: three-d-engrave windowtext 2.25pt; mso-element: para-border-div; padding: 15.0pt 15.0pt 15.0pt 15.0pt;">
<pre style="background: #FFFFC8; border: none; mso-border-alt: three-d-engrave windowtext 2.25pt; mso-padding-alt: 15.0pt 15.0pt 15.0pt 15.0pt; padding: 0cm; vertical-align: baseline;">=IFERROR(INDEX($E$3:$E$22,MATCH(ROWS($G$3:G3),$G$3:$G$22,0)),"") <o:p></o:p></pre>
</div>
<div style="background: white; margin-bottom: .0001pt; margin: 0cm; vertical-align: baseline;">
<span style="border: none windowtext 1.0pt; color: #343434; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">This
formula stacks all the matching names together without any blank cells in
between them. For example, if you type UNI, this column would show 2 and 9
together, and rest all cell would be blank.<v:shape alt="Excel Drop Down list with Search Suggestions - Helper Column 3" id="_x0000_i1030" style="height: 289.5pt; width: 238.5pt;" type="#_x0000_t75"></v:shape><o:p></o:p></div>
<h6 style="background: white; line-height: normal;">
Creating
the Dynamic Named Range<o:p></o:p></h6>
<div style="background: white; margin-bottom: .0001pt; margin: 0cm; vertical-align: baseline;">
Now
that the helper columns are in place, we need to create the dynamic named
range. This named range will only refer to those values that match the text
entered in the combo box. We will use this dynamic named range to show the
values in the drop-down box.<o:p></o:p></div>
<div style="background: white; margin-bottom: .0001pt; margin: 0cm; vertical-align: baseline;">
<span style="border: none windowtext 1.0pt; color: #343434; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">Note<span style="border: none windowtext 1.0pt; color: #343434; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">: <span style="border: none windowtext 1.0pt; color: #343434; font-family: "Verdana","sans-serif"; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;">In step 1 we entered
DropDownList in the ListFillRange option. Now we will create the named range
with the same name.<o:p></o:p></div>
<div style="background: white; margin-bottom: .0001pt; margin: 0cm; vertical-align: baseline;">
<ins>Here are the steps to create it:</ins><ins><o:p></o:p></ins></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l2 level1 lfo4; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
1.   <ins>Go to Formulas –> Name Manager.</ins><ins><o:p></o:p></ins></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l2 level1 lfo4; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
2.   <ins>In the name manager dialogue box click
New. It will open a New Name dialogue box.</ins><ins><o:p></o:p></ins></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l2 level1 lfo4; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
3.   <ins>In the Name Field enter </ins><ins>DropDownList</ins><ins><o:p></o:p></ins></div>
<div class="MsoNormal" style="background: white; line-height: 200%; margin-bottom: .0001pt; margin: 0cm; mso-list: l2 level1 lfo4; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
4.   <ins>In the Refers to Field enter the formula</ins><ins>: </ins><o:p></o:p></div>
<div class="MsoNormal" style="background: white; line-height: 200%; margin-bottom: .0001pt; margin-bottom: 0cm; vertical-align: baseline;">
<ins> =$H$3:INDEX($H$3:$H$22,MAX($G$3:$G$22),1)</ins><ins><o:p></o:p></ins></div>
<h4 style="background: white; line-height: normal; margin-top: 0cm;">
<ins>Step
3 – Putting the VBA Code to Work</ins><ins><o:p></o:p></ins></h4>
<div style="background: white; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 0cm; margin-right: 0cm; margin-top: 15.0pt; vertical-align: baseline;">
<ins>We
are almost there.<o:p></o:p></ins></div>
<div style="background: white; margin-bottom: .0001pt; margin: 0cm; vertical-align: baseline;">
<ins>The final part is to write a short <a href="https://trumpexcel.com/excel-macro-examples/" target="_blank">VBA code</a>. This code makes the drop down dynamic such
that it shows the matching items/names as you are typing in the search box.<o:p></o:p></ins></div>
<div style="background: white; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 0cm; margin-right: 0cm; margin-top: 15.0pt; vertical-align: baseline;">
<ins>To
add this code to your workbook:<o:p></o:p></ins></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l3 level1 lfo5; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
1.   <ins>Right click on the Worksheet tab and
select View Code.<o:p></o:p></ins></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin: 0cm; mso-list: l3 level1 lfo5; tab-stops: list 36.0pt; text-indent: -18.0pt; vertical-align: baseline;">
2.   <ins>In the VBA window, Copy and Paste the
following code:<o:p></o:p></ins></div>
<div style="background: #FFFFC8; border: groove windowtext 2.25pt; margin-left: -18.0pt; margin-right: 0cm; mso-border-alt: three-d-engrave windowtext 2.25pt; mso-element: para-border-div; padding: 15.0pt 15.0pt 15.0pt 15.0pt;">
<pre style="background: #FFFFC8; border: none; margin-left: 18.0pt; mso-border-alt: three-d-engrave windowtext 2.25pt; mso-list: l3 level1 lfo5; mso-padding-alt: 15.0pt 15.0pt 15.0pt 15.0pt; padding: 0cm; text-indent: -18.0pt; vertical-align: baseline;">3.      <span style="border: none windowtext 1.0pt; color: blue; font-family: "inherit","serif"; font-size: 11.5pt; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;"><ins>Private Sub ComboBox1_Change()</ins><ins><o:p></o:p></ins></pre>
<pre style="background: #FFFFC8; border: none; margin-left: 18.0pt; mso-border-alt: three-d-engrave windowtext 2.25pt; mso-list: l3 level1 lfo5; mso-padding-alt: 15.0pt 15.0pt 15.0pt 15.0pt; padding: 0cm; text-indent: -18.0pt; vertical-align: baseline;">4.      <span style="border: none windowtext 1.0pt; color: blue; font-family: "inherit","serif"; font-size: 11.5pt; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;"><ins>ComboBox1.ListFillRange = "DropDownList"</ins><ins><o:p></o:p></ins></pre>
<pre style="background: #FFFFC8; border: none; margin-left: 18.0pt; mso-border-alt: three-d-engrave windowtext 2.25pt; mso-list: l3 level1 lfo5; mso-padding-alt: 15.0pt 15.0pt 15.0pt 15.0pt; padding: 0cm; text-indent: -18.0pt; vertical-align: baseline;">5.      <span style="border: none windowtext 1.0pt; color: blue; font-family: "inherit","serif"; font-size: 11.5pt; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;"><ins>Me.ComboBox1.DropDown</ins><ins><o:p></o:p></ins></pre>
</div>
<div style="background: #FFFFC8; border: groove windowtext 2.25pt; mso-border-alt: three-d-engrave windowtext 2.25pt; mso-element: para-border-div; padding: 15.0pt 15.0pt 15.0pt 15.0pt;">
<pre style="background: #FFFFC8; border: none; mso-border-alt: three-d-engrave windowtext 2.25pt; mso-padding-alt: 15.0pt 15.0pt 15.0pt 15.0pt; padding: 0cm; vertical-align: baseline;"><span style="border: none windowtext 1.0pt; color: blue; font-family: "inherit","serif"; font-size: 11.5pt; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: major-fareast; padding: 0cm;"><ins>End Sub</ins><ins><o:p></o:p></ins></pre>
</div>
<div style="background: white; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 0cm; margin-right: 0cm; margin-top: 15.0pt; vertical-align: baseline;">
<ins>That's
it!!<o:p></o:p></ins></div>
<div style="background: white; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 0cm; margin-right: 0cm; margin-top: 15.0pt; vertical-align: baseline;">
<ins>You
are all set with your own Google type Search bar for a drop-down.<o:p></o:p></ins></div>
<div style="background: white; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 0cm; margin-right: 0cm; margin-top: 15.0pt; vertical-align: baseline;">
<ins>For
a better look and feel, you can cover cell B3 with the Combo Box and hide all
the helper columns. You can now show off a little with this amazing Excel
trick.<o:p></o:p></ins></div>
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0cm;">
 </div>

Contak

Alamat : https://trumpexcel.com/excel-drop-down-list-with-search-suggestions/ Excel Drop Down list with Search Suggestion Step 1 – Con...

Baca selengkapnya »

Contak

Formulir Kontak