+ Reply to Thread
Results 1 to 1 of 1

Using Typingaid for autocompletion & intelisense in VBE

  1. #1
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    997

    Using Typingaid for autocompletion & intelisense in VBE

    Using Typingaid for autocompletion & intelisense in Visual Basic for Application Editor

    I just want to share about Typingaid, it’s a freeware .
    To help me writing vba code faster I use Typingaid as autocompletion or autoexpander tool.
    Basically here’s how it works:
    You can insert 2 types of entry in the word list file (Wordlist.txt):

    First, without keyword:

    Say, you insert some entries like this:
    Range("A1")
    Range("A:B")
    Range(Cells(2, "A"), Cells(a, "B"))
    Range("A" & i & ":" & "B" & i)

    Then when you type (in VBE window) ‘ra’ , those entries will pop up like these

    Name:  ra - popup.jpg
Views: 338
Size:  22.2 KB

    Then you can use arrow keys to select it followed by Enter OR you can just hit a number.


    Second, with keyword:
    You need to separate between the keyword & the complete word using ‘|r|’
    Say, you insert entries like this:
    xlup|r|set rng = Range("A1", Cells(Rows.Count, "A").End(xlUp))
    xlup|r|set rng = Range("A1:C" & Cells(Rows.Count, "A").End(xlUp).Row)
    xlup|r|n = Range("A" & Rows.count).End(xlUp).row

    Then when you type ‘xl’ , those entries will pop up like these:

    Name:  xlup.jpg
Views: 323
Size:  26.7 KB

    Problem & limitation:
    - You can’t have a multiline entry. But actually there is a work around, but I can’t figure out how to implement it. Here’s the discussion:
    https://autohotkey.com/boards/viewto...139962#p139962
    - If you have Auto List Member in VBE activated then sometimes it will pop up simultaneously with Typingaid list. The Typingaid intelisense will override the Auto List Member.


    Installation & setting
    - Download here:
    https://autohotkey.com/boards/viewtopic.php?f=6&t=5644
    You may download TypingAid v2.22.0 Precompiled Executable
    - Unzip the downloaded file
    - Run ‘TypingAid.ahk’
    - Create a text file, name it ‘WordList.txt’ & place it in the same folder as ‘TypingAid.ahk’ (i.e \TypingAid-2.22.0.0\Source\
    - Insert some entries in the file then save.
    - In the taskbar find Typingaid icon > right click > click Setting
    - To activate Typingaid in VBE you need to set this:
    You need to type ‘Microsoft Visual Basic’ here:

    Name:  set visual basic window 1.jpg
Views: 372
Size:  30.3 KB

    - You can set after how many character you type in to show the entry list. I set it to 2.

    Name:  after n char.jpg
Views: 375
Size:  34.1 KB
    - You can set the key to trigger the autocomplete in General settings > Auto Complete Keys


    That’s it.
    Sorry for my bad English, it’s not my native language.
    Last edited by Akuini; 11-19-2018 at 09:24 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Problem in autocompletion of data
    By rishi.bhorania in forum Excel General
    Replies: 0
    Last Post: 09-28-2011, 11:14 AM
  2. Replies: 1
    Last Post: 10-14-2010, 06:13 AM
  3. Autocompletion and Icons
    By Bowzerbro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-03-2009, 05:00 AM
  4. How to achieve table AUTOcompletion
    By Sebastian42 in forum Excel General
    Replies: 0
    Last Post: 12-09-2007, 08:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1