How to make Dynamic Search-bar in Excel 365 FOR MAC without ActiveX

%3CLINGO-SUB%20id%3D%22lingo-sub-2420900%22%20slang%3D%22en-US%22%3EHow%20to%20make%20Dynamic%20Search-bar%20in%20Excel%20365%20FOR%20MAC%20without%20ActiveX%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2420900%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20make%20a%20dynamic%20search%20bar%20that%20%3CSTRONG%3Efilters%20as%20you%20type%20the%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSTRONG%3ESince%20I'm%20Using%20excel%20365%20on%20my%20MacBook%20there%20is%20%3CSTRONG%3ENO%20ActiveX%20%3C%2FSTRONG%3Ecomponent%2C%20my%20only%20availability%20to%20create%20this%20are%20using%3CSTRONG%3E%20macro's%20and%20VBA%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Esince%20I'm%20new%20to%20excel%20I%20have%20no%20idea%20how%20to%20create%20the%20formula%20for%20all%20of%20this.%20please%20help%20me.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ERequirements%20for%20this%20%3A%3CBR%20%2F%3E%3CSTRONG%3ECreate%20it%20without%20ActiveX%26nbsp%3B%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3ECreate%20a%20filter%20as%20you%20type%20in%20the%20searchbox%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CBR%20%2F%3E%3C%2FSTRONG%3EKind%20regards%20%2C%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EDG%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Schermafbeelding%202021-06-07%20om%2008.39.16.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286750iB5506B5D31D51EC7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Schermafbeelding%202021-06-07%20om%2008.39.16.png%22%20alt%3D%22Schermafbeelding%202021-06-07%20om%2008.39.16.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2420900%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I need to make a dynamic search bar that filters as you type the

Since I'm Using excel 365 on my MacBook there is NO ActiveX component, my only availability to create this are using macro's and VBA 

since I'm new to excel I have no idea how to create the formula for all of this. please help me. 

Requirements for this :
Create it without ActiveX 
Create a filter as you type in the searchbox


Kind regards , 

DG

Schermafbeelding 2021-06-07 om 08.39.16.png

 

0 Replies