Visit http://www.TeachMsOffice.com for more, including Excel Consulting.
This tutorial shows you how to find a cell with a certain value anywhere throughout a spreadsheet. You will learn how to search for text, numbers, and values stored in variables. This is a great lesson for learning how to values within cells in your excel worksheets.
For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachMsOffice.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!
You actually apply it to a button in the form that takes input from the text field and then searches the workbook/worksheet or whatever for that input and then does something with that input. It really depends on what you need done but that is the process you should use to be able to search from a form. PM me if you need more specific help.
after you find the word or cell select that cell with the macro or just make it active and you can then use this line of code:
Selection.Font.Bold = True
Thanks! Glad I could help 🙂
You are not hell, you are heaven!
Thanks for all your tutorials … Nice of you to share this knowledge
I want to have a cell and a button so that the user of my spreadsheet can search within the worksheet. i wanted it so that within the cell you can type something to search and then click the button to run the macro in order to find the cell.
@ibz28 Just use the info in this tutorial as well as the tutorial for getting a value from a cell into a macro and then the tutorial on how to assign a macro to a button and that should get you on your way to completing the task.
HI, I am interested to purchase a seriess of macro tutorials that lead me especifficaly to create either a MRP or Data warehouse kanban.
I am a professional in the Planning area and i am very interested to learn those kind of macros…
Please reply what your suggestion for me is, I already went to the teachmsoffice page but could not find nothing like it…
Thank you in advance…
@caballero4321 I will send you a message on here because there's no quick answer.