PDA

View Full Version : Search function using VBA



itsraghus
02-12-2019, 02:42 PM
Hi All,
Hoping you can help I've been searching and searching for the right VBA code for the job but so far haven't found anything. I have limited working knowledge of macros and love using them as it makes my life much easier but as of yet havn't worked out how to write them myself, hence why i need your help.
I have a workbook with around 5 sheets with two columns each. Column A - Name of Test Type and Column B - Definition of Test Type and i want create a search function on the first sheet where i can type in a search criteria in a certain cell e.g. "Test Automation" and press the search button and it will search all the sheets and will give me the definition of this test type.
Thanks in advance!

Paul_Hossler
02-12-2019, 05:18 PM
Little too much code in various places to post, but look at this example

MIght give you some ideas

itsraghus
02-13-2019, 07:41 AM
Thank you for the quick response. This really helps. :)

Paul_Hossler
02-13-2019, 08:18 AM
Thank you for the quick response. This really helps. :)

You've still got your work cut out for you

Build the sheets, make the UserForm prettier, maybe Hide the Test/Definition sheets from the user, maybe make the 'Into' sheet prettier and add some instructions

Ask again if there are any questions