Excel Macro VBA Tip 4 - Find Cells in Excel with Macros using the Find Method
Loading...
Loading...
15,024
Loading...
Uploaded by ExcelisHell on Oct 29, 2009
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!
- 15 likes, 0 dislikes
-
Uploader Comments (ExcelisHell)
see all
All Comments (15)
-
Thanks for all your tutorials ... Nice of you to share this knowledge
-
You are not hell, you are heaven!
Loading...
8:36
Excel Macro VBA Tip 5 - Learn How to Input Values, Text, Numbers, and Formulas into Cells in Excelby ExcelisHell20,129 views- 5:10
Excel Macro VBA Tip 6 - IF Then Statement in Excel Macros and VBAby ExcelisHell15,231 views
- 8:12
Excel Macro VBA Tip 3 - Using The Range Property in Excel Macros to Select Columns and Rowsby ExcelisHell21,044 views
- 7:11
Excel Macro VBA Tip 2 - Using The Range Property to Select Cells in Excelby ExcelisHell14,097 views
- 7:09
VBA Code Example (Variables and Cells)by peterdcasey3,431 views
- 6:14
Excel Macro VBA Tip 23 - Put a Time Delay in Macros Pause a Macro for a Given Amount of Time Excelby ExcelisHell6,776 views
- 9:23
Edit Macros in Excel - Make Dynamic Cell References (2 of 2)by ExcelisHell9,844 views
- 5:49
Excel Lookup/Search Tip 6 - Vlookup with a Drop Down Menu and Data Validationby ExcelisHell16,927 views
- 10:46
Digital Dashboards Using Microsoft Excel and VBAby wjj483238,594 views
- 3:58
Excel Macro Tutorial -by MYWSITEAM4,332 views
- 9:45
Excel Macro VBA Tip 16 - Using Offset in Excel Macros and VBAby ExcelisHell8,855 views
- 3:35
Assign a Macro to a Button, Check box, or any object in Microsoft Excelby ExcelisHell44,307 views
- 6:39
Excel Macro VBA Tip 9 - Enter Formulas in Excel with a Macroby ExcelisHell14,451 views
- 4:21
Excel Macro VBA Tip 10 - Enter Array Formulas into Cells in Excel with a Macroby ExcelisHell10,034 views
- 0:22
Advanced Excel Spreadsheet - Sudoku Solver (quick view)by Erni7608032,327 views
- 8:09
Excel Macros Tutorial (Record and Save Macro in Excel)by slembke143,826 views
- 9:16
Excel VBA Beginner Tutorial - Sorting Databy VBA4Excel43,592 views
- 3:12
ExcelExperts.com - VBA Tips - Find The Last Cellby NickViv1,701 views
- 13:43
Learning Visual Basic 6 Programming: Lesson 1by jaywalker512103,206 views
- 1:17
How to email your spreadsheet using macros in Excelby MHELP2U5,143 views
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 1 year ago
@caballero4321 I will send you a message on here because there's no quick answer.
ExcelisHell 1 year ago
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 1 year ago
@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.
ExcelisHell 1 year ago
I love you man! You are so good at explaining this! I learned a lot. Very clear!
nerijusmikolaitis 2 years ago
Thanks! Glad I could help :)
ExcelisHell 2 years ago