Skip to content

Instantly share code, notes, and snippets.

@s-hiiragi

s-hiiragi/excel_toggle_auto_complete.bas

Last active December 6, 2024 22:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save s-hiiragi/a232d9be2f8f26fcdeaaf7401d193bf5 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save s-hiiragi/a232d9be2f8f26fcdeaaf7401d193bf5 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. s-hiiragi revised this gist Dec 6, 2024. No changes.
  2. s-hiiragi created this gist Dec 6, 2024.
    9 changes: 9 additions & 0 deletions excel_toggle_auto_complete.bas
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,9 @@
    ' オートコンプリートを切り替える
    '
    ' 以下のオプションをON/OFFします
    ' オプション＞詳細設定＞編集オプション＞オートコンプリートを有効にする
    '
    Sub オートコンプリート切替()
    Application.EnableAutoComplete = Not Application.EnableAutoComplete
    MsgBox "オートコンプリートを" & IIf(Application.EnableAutoComplete, "有効", "無効") & "にしました"
    End Sub