Forum Discussion

KAM_Mumin's avatar
KAM_Mumin
Brass Contributor
Oct 08, 2022
Solved

MS Excel Flash Fill and Filtering Option with VBA .

Hi Everyone! I want to fill up cell manually by typing keywords but the problem is which text I want to type that is so big word some time and there are so many types of items there which I need to ...
  • NikolinoDE's avatar
    Oct 09, 2022

    KAM_Mumin 

    Attached is an older example (Excel 97) with VBA.

    You only need to type letters in the drop down box and it will show you all existing ones with those letters for you to select.

    I'm not sure if this is exactly what you're looking for, but it might help.

    Haven't tried it in Excel 365.

     

     Hope I was able to help you with this file.

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources