Note: The other languages of the website are Google-translated. Back to English
ログイン  \/ 
x
or
x
今すぐ登録  \/ 
x

or

Excelのドロップダウンリストに入力するときにオートコンプリートするにはどうすればよいですか?

大きなアイテムを含むデータ検証ドロップダウンリストがある場合は、適切なアイテムを見つけるためだけにリストを上下にスクロールするか、リストボックスに単語全体を直接入力する必要があります。 ドロップダウンリストの最初の文字を入力するときにオートコンプリートを許可する方法があれば、すべてが簡単になります。 このチュートリアルでは、それを実現するのに役立つVBAメソッドを提供します。

VBAコードを使用してドロップダウンリストに入力するとオートコンプリート
ドロップダウンリストのその他のチュートリアル...


VBAコードを使用してドロップダウンリストに入力するとオートコンプリート

セルに対応する文字を入力した後、ドロップダウンリストをオートコンプリートするには、次のようにしてください。

まず、コンボボックスをワークシートに挿入し、そのプロパティを変更する必要があります。

1.オートコンプリートするドロップダウンリストセルを含むワークシートを開きます。

2.コンボボックスを挿入する前に、Excelリボンに[開発者]タブを追加する必要があります。 [開発者]タブがリボンに表示されている場合は、 ステップ3にシフト。 それ以外の場合は、次のようにします。クリック フィレット > オプション を開く オプション 窓。 これで Excelのオプション ウィンドウ、クリック リボンをカスタマイズする 左側のペインで、 ディベロッパー ボックスをクリックし、 OK ボタン。 スクリーンショットを参照してください:

3。 クリック ディベロッパー > インセット > コンボボックス(ActiveXコントロール).

4.現在のワークシートにコンボボックスを描画します。 それを右クリックして、 プロパティ 右クリックメニューから。

5。 の中に プロパティ ダイアログボックスで、元のテキストを置き換えてください (氏名) フィールド付き TempCombo。

6。 オフにする デザインモード クリックして ディベロッパー > デザインモード。

次に、以下のVBAコードを適用します

7.現在のシートタブを右クリックして、 コードを表示 コンテキストメニューから。 スクリーンショットを参照してください:

8.オープニングで Microsoft Visual Basic for Applications ウィンドウで、以下のVBAコードをコピーしてワークシートのコードウィンドウに貼り付けてください。

VBAコード:ドロップダウンリストに入力するとオートコンプリート

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Update by Extendoffice: 2020/01/16
    Dim xCombox As OLEObject
    Dim xStr As String
    Dim xWs As Worksheet
    Dim xArr
    
    Set xWs = Application.ActiveSheet
    On Error Resume Next
    Set xCombox = xWs.OLEObjects("TempCombo")
    With xCombox
        .ListFillRange = ""
        .LinkedCell = ""
        .Visible = False
    End With
    If Target.Validation.Type = 3 Then
        Target.Validation.InCellDropdown = False
        Cancel = True
        xStr = Target.Validation.Formula1
        xStr = Right(xStr, Len(xStr) - 1)
        If xStr = "" Then Exit Sub
        With xCombox
            .Visible = True
            .Left = Target.Left
            .Top = Target.Top
            .Width = Target.Width + 5
            .Height = Target.Height + 5
            .ListFillRange = xStr
            If .ListFillRange = "" Then
                xArr = Split(xStr, ",")
                Me.TempCombo.List = xArr
            End If
            .LinkedCell = Target.Address
        End With
        xCombox.Activate
        Me.TempCombo.DropDown
    End If
End Sub
Private Sub TempCombo_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    Select Case KeyCode
        Case 9
            Application.ActiveCell.Offset(0, 1).Activate
        Case 13
            Application.ActiveCell.Offset(1, 0).Activate
    End Select
End Sub

9。 押す 他の + Q キーを同時に閉じて Microsoft VisualBasicアプリケーション 窓。

これ以降、ドロップダウンリストのセルをクリックすると、ドロップダウンリストに自動的にプロンプ​​トが表示されます。 文字の入力を開始して、選択したセルに対応する項目を自動的に入力することができます。 スクリーンショットを参照してください:

注意: このコードは、結合されたセルでは機能しません。

Excelのチェックボックスを使用してドロップダウンリストを簡単に作成します。

  チェックボックス付きのドロップダウンリスト の有用性 Kutools for Excel 必要に応じて、指定した範囲のチェックボックス、現在のワークシート、現在のワークブック、または開いているすべてのワークブックを含むドロップダウンリストを簡単に作成できます。
今すぐダウンロードしてお試しください! (30日間の無料トレイル)


関連記事:

Excelで複数のチェックボックスを含むドロップダウンリストを作成するにはどうすればよいですか?
多くのExcelユーザーは、一度にリストから複数のアイテムを選択するために、複数のチェックボックスを備えたドロップダウンリストを作成する傾向があります。 実際には、データ検証を使用して複数のチェックボックスを含むリストを作成することはできません。 このチュートリアルでは、Excelで複数のチェックボックスを備えたドロップダウンリストを作成するXNUMXつの方法を紹介します。 このチュートリアルでは、問題を解決する方法を説明します。

Excelで別のブックからドロップダウンリストを作成する
ブック内のワークシート間でデータ検証ドロップダウンリストを作成するのは非常に簡単です。 しかし、データ検証に必要なリストデータが別のブックにある場合は、どうしますか? このチュートリアルでは、Excelの別のブックからドロップファウンリストを作成する方法について詳しく学習します。

Excelで検索可能なドロップダウンリストを作成する
多数の値を持つドロップダウンリストの場合、適切な値を見つけるのは簡単な作業ではありません。 以前、ドロップダウンボックスに最初の文字を入力したときにドロップダウンリストをオートコンプリートする方法を導入しました。 オートコンプリート機能に加えて、ドロップダウンリストを検索可能にして、ドロップダウンリストで適切な値を見つける作業効率を高めることもできます。 ドロップダウンリストを検索可能にするには、このチュートリアルの方法を試してください。

Excelのドロップダウンリストで値を選択すると、他のセルに自動入力されます
セル範囲B8:B14の値に基づいてドロップダウンリストを作成したとします。 ドロップダウンリストで任意の値を選択する場合、セル範囲C8:C14の対応する値が選択したセルに自動的に入力されるようにします。 問題を解決するために、このチュートリアルの方法はあなたに有利になります。

ドロップダウンリストのその他のチュートリアル...


最高のオフィス生産性ツール

Kutools for Excelはほとんどの問題を解決し、生産性を80%向上させます

  • 再利用: すばやく挿入 複雑な数式、チャート および以前に使用したものすべて。 セルを暗号化する パスワード付き。 メーリングリストを作成する そしてメールを送る...
  • スーパーフォーミュラバー (複数行のテキストと数式を簡単に編集できます); 読書レイアウト (多数のセルを簡単に読み取って編集する); フィルター範囲に貼り付け...
  • セル/行/列をマージする データを失うことなく; 分割セルコンテンツ; 重複する行/列を組み合わせる...重複セルを防止します。 範囲を比較する...
  • [複製]または[一意]を選択します 行; 空白行を選択 (すべてのセルは空です); スーパーファインドとファジーファインド 多くのワークブックで; ランダム選択...
  • 正確なコピー 数式参照を変更せずに複数のセル。 参照の自動作成 複数のシートに; 箇条書きを挿入、チェックボックスなど...
  • テキストを抽出、テキストの追加、位置による削除、 スペースを削除する; ページング小計の作成と印刷。 セルの内容とコメントを変換する...
  • スーパーフィルター (フィルタースキームを保存して他のシートに適用します); 高度な並べ替え 月/週/日、頻度など。 特殊フィルター 太字、斜体...
  • ワークブックとワークシートを組み合わせる; キー列に基づいてテーブルをマージします。 データを複数のシートに分割; xls、xlsx、PDFをバッチ変換...
  • 300以上の強力な機能。 Office / Excel2007-2019および365をサポートします。すべての言語をサポートします。 企業や組織に簡単に導入できます。 全機能30日間の無料トライアル。 60日間の返金保証。
kteタブ201905

Officeタブは、タブ付きのインターフェイスをOfficeにもたらし、作​​業をはるかに簡単にします

  • Word、Excel、PowerPointでタブ付きの編集と読み取りを有効にする、パブリッシャー、アクセス、Visioおよびプロジェクト。
  • 新しいウィンドウではなく、同じウィンドウの新しいタブで複数のドキュメントを開いて作成します。
  • 生産性が50%向上し、毎日何百ものマウスクリックが減ります。
officetab下部
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Nat · 13 days ago
    Thank you, this worked for me.
  • To post as a guest, your comment is unpublished.
    Jesus Bermudez · 1 months ago
    Hi, thanks for your code. I have a problem, It's not working. My data for the validation list is in other sheet (Also is a excel table Ctrl + T because I need enter new data every day), I dont know if any of these are the problem. Can you help me with this?
  • To post as a guest, your comment is unpublished.
    opalmagic · 1 months ago
    @stefany Check out the world's best site for selling opal rings opal jewelry
  • To post as a guest, your comment is unpublished.
    stefany · 2 months ago
    hi, thanks for your code. I would like to autocomplete and make multiple selections in a drop down list. Can you help me please?, thank you
  • To post as a guest, your comment is unpublished.
    Dilshan · 2 months ago
    @crystal Hi,
    I am trying to pull that list data from another sheet but it does not work. below is my code
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    'Update by Extendoffice: 20190812
    Dim xCombox As OLEObject
    Dim xStr As String
    Dim xWs As Worksheet
    Dim xArr
    Dim xRgStr As String
    Dim xRg As Range
    xRgStr = "MAINInput!$D:$D"
    'MAINInput = sheet name where the list is available


    Set xWs = Application.ActiveSheet
    On Error Resume Next
    Set xCombox = xWs.OLEObjects("cmbEmployee")
    With xCombox
    .ListFillRange = ""
    .LinkedCell = ""
    .Visible = False
    End With
    Set xRg = Intersect(Range(xRgStr), Target)
    If xRg Is Nothing Then Exit Sub
    If Target.Validation.Type = 3 Then
    Target.Validation.InCellDropdown = False
    Cancel = True
    xStr = Target.Validation.Formula1
    xStr = Right(xStr, Len(xStr) - 1)
    If xStr = "" Then Exit Sub
    With xCombox
    .Visible = True
    .Left = Target.Left
    .Top = Target.Top
    .Width = Target.Width + 5
    .Height = Target.Height + 5
    .ListFillRange = xStr
    If .ListFillRange = "" Then
    xArr = Split(xStr, ",")
    Me.cmbEmployee.List = xArr
    End If
    .LinkedCell = Target.Address
    End With

    xCombox.Activate
    Me.cmbEmployee.DropDown
    End If
    End Sub
    Private Sub cmbEmployee_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    Select Case KeyCode
    Case 9
    Application.ActiveCell.Offset(0, 1).Activate
    Case 13
    Application.ActiveCell.Offset(1, 0).Activate
    End Select
    End Sub
  • To post as a guest, your comment is unpublished.
    wendy · 4 months ago
    @crystal I have done that - saved as a macro-enabled workbook but it still all disappears when you close the file. Thanks, Wendy

  • To post as a guest, your comment is unpublished.
    crystal · 5 months ago
    @taras.samolyuk Good day,
    Would you provide a screenshot of what you are trying to do?
  • To post as a guest, your comment is unpublished.
    krish · 5 months ago
    Hello thanks for the code it works great.
    But i want to auto expand drop down list when i move to next cell by pressing enter key without clicking on arrow button (or) alt+down.
    Thanks in advance.
  • To post as a guest, your comment is unpublished.
    taras.samolyuk · 6 months ago
    Hello, is there a chance to add dependency to select date and in the next column to the proposed choices?
  • To post as a guest, your comment is unpublished.
    Christiam Alfonzo · 6 months ago
    como hago para agregar esta función
    =INDIRECTO("tabla1[columna]")
    al código
    • To post as a guest, your comment is unpublished.
      Ben · 10 days ago
      @Christiam Alfonzo @Crystal I'm having the same problem. One of my lists uses an INDIRECT formula (based on what they choose in the first column) to generate the list. With this code, now the formula appears instead of the list.
  • To post as a guest, your comment is unpublished.
    crystal · 6 months ago
    @Danielle Hi,
    The code works well in my case. It is not easy to figure out the problem as you described above. Would you mind sending your worksheet to my email address?
  • To post as a guest, your comment is unpublished.
    Danielle · 6 months ago
    I tried to use this method. I added the code. After that I add the range needed. Looks all fine. Then I test and the combobox dissapears directly after filling it. So the code works, but its not usable. What do I do wrong?
    Kind regards, Danielle
  • To post as a guest, your comment is unpublished.
    coltan123 · 8 months ago
    Code is working , but data validation is not working. For example, when i set the data validation to be red/bue/yellow, it does not show error message when i type green
  • To post as a guest, your comment is unpublished.
    crystal · 9 months ago
    @Mhyk Hi,
    Methods in this tutorial can do you a favor:
    How To Auto Populate Other Cells When Selecting Values In Excel Drop Down List?
    https://www.extendoffice.com/documents/excel/2400-excel-drop-down-list-auto-populate.html
  • To post as a guest, your comment is unpublished.
    Mhyk · 9 months ago
    Hi I have some difficulties with my excel work. I would like to know if there is a method to autofill the cell I desire?
    Example
    1 = san pedro
    2 = santa rosa
    3 = calamba
    4 = san pablo
    and so on.

    I have a list with correspoding numbers. If I input number 1 in Cell A5 I would like it to automatically fill the Cell B5 with its corresponding list name (san pedro) and if I input 3 in A5, B5 will be = calamba.
    thank you. for the help, Im having trouble to find a solution to this hope to find answers.
    Thank you and God Bless.


  • To post as a guest, your comment is unpublished.
    Sisi · 9 months ago
    Hi Guys,


    I have made 2 different drop down list searchable in 1 sheet, the fist is working well but the second drop down list is showing me the formula of indirect as the second drop down list is indirect of the first. I have apply the VBA with combo and so on but still the second list is showing me the formula. how to I fix this?
  • To post as a guest, your comment is unpublished.
    Simona Muresan · 9 months ago
    Hi Guys,


    I have made 2 different drop down list searchable in 1 sheet, the fist is working well but the second drop down list is showing me the formula of indirect as the second drop down list is indirect of the first. I have apply the VBA with combo and so on but still the second list is showing me the formula. how to I fix this?

  • To post as a guest, your comment is unpublished.
    Alistair · 9 months ago
    @crystal Hi there, this is a great solution, but for some reason, in the original code, the combox was hidden when the cell with the data validation was not active, and only visible when the cell was selected.
    With this code, we get undo back, which is perfect, but the combox does not auto-hide again when you click off.
    Do you have a solution for this?

    Thanks,

    Alistair
  • To post as a guest, your comment is unpublished.
    Donald · 10 months ago
    @crystal Hi Cristal, great answer. Now if on the same worksheet I want to add another combo box that calls data from a third sheet, how would the code look like as I tried and got no result. I will appreciate your support. Donald
  • To post as a guest, your comment is unpublished.
    crystal · 10 months ago
    @Leonardo Hi Leonardo,
    The VBA works for all data validation drop down lists in the worksheet.
  • To post as a guest, your comment is unpublished.
    Juan Carlos · 10 months ago
    Hello, I have a problem with this method and I already use a list validated with an indirect function to refer to the range of a table and when applying this macro it shows me only the indirect formula in the list! How could I solve this problem?
  • To post as a guest, your comment is unpublished.
    Leonardo · 10 months ago
    Hi! Is it possible to disable the combo box scrolling list when I click on the cell? and leave it active only if I click on the arrow, thanks!
  • To post as a guest, your comment is unpublished.
    Leonardo · 10 months ago
    Hello, is it possible to replicate this in a complete column? I mean that each individual row of a column has this possibility or at least 1000 rows in a simple way. Thank you!
  • To post as a guest, your comment is unpublished.
    ahmad zaid · 10 months ago
    @crystal It's work in cell with list but when i move or tap or select any cell with no list ..the up message talked you about always show..

  • To post as a guest, your comment is unpublished.
    crystal · 10 months ago
    @Rohit Hi Rohit,
    After applying the code, please save the workbook as an Excel Macro-Enabled Workbook before closing the file.
  • To post as a guest, your comment is unpublished.
    gurita_22 · 10 months ago
    If you use this method with one combobox/sheet i guess it's flawless.

    I used this method with three comboboxes on one sheet with 3 different ListFillRange.
    Dropdown keep showing up on different combobox than what i'm typing in.
    1. I type and select correctly from the first.
    2. When i go to second combo, the third dropdown pops up.(I have to select the"", as it is still empty)
    then i can search my second combobox.
    3. When i go to the third, the first dropdown pops up, I reselect the only item(as there is only one that was already selected in the first step)
    After this i can add the content in the third dropdown.



    All subs are on sheet1's vba window.
    Now i'm trying to spit code in different modules, but can't really make it work.
    Search works, but i always have to push the dropdown arrow to see available results to select. Dropdown doesn't pop up at all.

    using 365, but i have to make "sheet" work on excel 2010
  • To post as a guest, your comment is unpublished.
    Rohit · 10 months ago
    The command works when first applied. But after saving the file, when i reopen it the drop down itself disappears.
  • To post as a guest, your comment is unpublished.
    crystal · 10 months ago
    @ahmadzaid Hi,
    I tried the VBA in Excel 2010 and it works well.
    The drop down list should be data validation drop-down list which is created by clicking Data > Data Validation....
  • To post as a guest, your comment is unpublished.
    ahmadzaid · 10 months ago
    @crystal I get an error message (1004) - the debug highlights ‘If Target.Validation.Type =3 Then’


    fo info. I use excel 2010
  • To post as a guest, your comment is unpublished.
    ahmadzaid · 10 months ago
    I get an error message (1004) - the debug highlights ‘If Target.Validation.Type =3 Then’


    for info .. I use excel 2010

  • To post as a guest, your comment is unpublished.
    crystal · 11 months ago
    @Carlos Hi Carlos,
    Remove the "cancel = true" line from the VBA, then try again.
  • To post as a guest, your comment is unpublished.
    Carlos · 11 months ago
    @crystal Hi. Office 365 Pro Plus
  • To post as a guest, your comment is unpublished.
    crystal · 11 months ago
    @Carlos Hi Carlos,
    Which Excel version are you using?
  • To post as a guest, your comment is unpublished.
    Carlos · 11 months ago
    Hi! Thanks for this code!

    I'm getting a compile error saying "variable not defined", it highlights the "cancel = true" line
  • To post as a guest, your comment is unpublished.
    crystal · 11 months ago
    @Reinaldo Yajure Hi Reinaldo Yajure,
    Please apply the below VBA code. The problem is fixed. Sorry for the inconvenience.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    'Update by Extendoffice: 2020/05/19
    Dim xCombox As OLEObject
    Dim xStr As String
    Dim xWs As Worksheet
    Dim xArr

    Set xWs = Application.ActiveSheet
    On Error Resume Next
    If Target.Validation.Type = 3 Then
    Target.Validation.InCellDropdown = False
    Cancel = True
    xStr = Target.Validation.Formula1
    xStr = Right(xStr, Len(xStr) - 1)
    If xStr = "" Then Exit Sub
    Set xCombox = xWs.OLEObjects("TempCombo")
    With xCombox
    .ListFillRange = ""
    .LinkedCell = ""
    .Visible = False
    End With
    With xCombox
    .Visible = True
    .Left = Target.Left
    .Top = Target.Top
    .Width = Target.Width + 5
    .Height = Target.Height + 5
    .ListFillRange = xStr
    If .ListFillRange = "" Then
    xArr = Split(xStr, ",")
    Me.TempCombo.List = xArr
    End If
    .LinkedCell = Target.Address
    End With
    xCombox.Activate
    Me.TempCombo.DropDown
    End If
    End Sub
    Private Sub TempCombo_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    Select Case KeyCode
    Case 9
    Application.ActiveCell.Offset(0, 1).Activate
    Case 13
    Application.ActiveCell.Offset(1, 0).Activate
    End Select
    End Sub
  • To post as a guest, your comment is unpublished.
    Mitchell · 11 months ago
    Hi Crystal,

    Absolutely perfect and thank you for the code. However when i press enter the cell automatically goes down. How can I make the cell go to the right when I press enter?

    MItchell

  • To post as a guest, your comment is unpublished.
    crystal · 11 months ago
    @Sergio Hi Sergio,
    The method in this article can help you:
    How To Create A Searchable Drop Down List In Excel?
    https://www.extendoffice.com/documents/excel/2439-excel-drop-down-list-search.html
  • To post as a guest, your comment is unpublished.
    crystal · 11 months ago
    @Sandeep Sharma Hi Sandeep Sharma,
    In the Properties dialog box of the Combo box (step 5 of this tutorial), please find the ListRows field and then change the number 8 to 12 under the Alphabetic tab.
  • To post as a guest, your comment is unpublished.
    Sergio · 1 years ago
    Hi,

    Is it possible to show the matches with the caracter your typping using this code and format of combox?

    Example:

    You have a list with Onion, Black Onion, Green Onion, Red Onion...

    And in the combox you type: "On", so the drop down list show all the values existing on the list that matchs with "On".

    Thanks
  • To post as a guest, your comment is unpublished.
    Reinaldo Yajure · 1 years ago
    When I applied this code to my worksheet, the Undo function is disabled (but only for this sheet in the workbook) -- is there a way to fix this so that undo can still be used?
  • To post as a guest, your comment is unpublished.
    Sandeep Sharma · 1 years ago
    is there any way to increase the list size as it is showing up only 10 line items as i have 12 lines
  • To post as a guest, your comment is unpublished.
    crystal · 1 years ago
    @Jonas Hi Jonas,
    The Tab key and the Enter key can work normally. But can't help with the Arrows yet. Sorry for the inconvenience.
  • To post as a guest, your comment is unpublished.
    Jonas · 1 years ago
    How can I Use Tab/Arrows/Enter to move to another cell once the current cell is filled? Thanks
  • To post as a guest, your comment is unpublished.
    Jonas · 1 years ago
    @crystal It doesnt work for me either, I can still enter items that are not on the list. can you please help!
  • To post as a guest, your comment is unpublished.
    Ramitha · 1 years ago
    Hi . It is a very useful code . However , I cannot use it on horizontal tables which are is a reference for vertical drop downs. Is there a solution ?
  • To post as a guest, your comment is unpublished.
    K1000z · 1 years ago
    @crystal Looks good.Thanks Crystal.
  • To post as a guest, your comment is unpublished.
    crystal · 1 years ago
    @K1000z Hi,
    If you only want the column H to be affected, please try the below VBA code. But it is only available in one worksheet. For multiple sheets, you need to add the code to each sheet code window. Hope I can help.

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    'Update by Extendoffice: 2019/8/14
    Dim xCombox As OLEObject
    Dim xStr As String
    Dim xWs As Worksheet
    Dim xArr
    Dim xRgStr As String
    Dim xRg As Range
    xRgStr = "H:H"

    Set xWs = Application.ActiveSheet
    On Error Resume Next
    Set xCombox = xWs.OLEObjects("TempCombo")
    With xCombox
    .ListFillRange = ""
    .LinkedCell = ""
    .Visible = False
    End With
    Set xRg = Intersect(Range(xRgStr), Target)
    If xRg Is Nothing Then Exit Sub
    If Target.Validation.Type = 3 Then
    Target.Validation.InCellDropdown = False
    Cancel = True
    xStr = Target.Validation.Formula1
    xStr = Right(xStr, Len(xStr) - 1)
    If xStr = "" Then Exit Sub
    With xCombox
    .Visible = True
    .Left = Target.Left
    .Top = Target.Top
    .Width = Target.Width + 5
    .Height = Target.Height + 5
    .ListFillRange = xStr
    If .ListFillRange = "" Then
    xArr = Split(xStr, ",")
    Me.TempCombo.List = xArr
    End If
    .LinkedCell = Target.Address
    End With

    xCombox.Activate
    Me.TempCombo.DropDown
    End If
    End Sub
    Private Sub TempCombo_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    Select Case KeyCode
    Case 9
    Application.ActiveCell.Offset(0, 1).Activate
    Case 13
    Application.ActiveCell.Offset(1, 0).Activate
    End Select
    End Sub
  • To post as a guest, your comment is unpublished.
    crystal · 1 years ago
    @Jerome Hi Jerome,
    The Tab key still works well in my case after applying the code. Which Excel version are you using?
  • To post as a guest, your comment is unpublished.
    crystal · 1 years ago
    @Don P. Hi Don P.
    Only the 1-MatchEntryComplete option can make it work. Sorry can't help you for that.
  • To post as a guest, your comment is unpublished.
    crystal · 1 years ago
    @Billy Hi Billy,
    Which Excel version are you using?