Excel Macro VBA Tip 4 - Find Cells in Excel with Macros using the Find Method

[caballero4321]

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...

[ExcelisHell]

@caballero4321 I will send you a message on here because there's no quick answer.

[ibz28]

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.

[ExcelisHell]

@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.

[funniq]

Thanks for all your tutorials ... Nice of you to share this knowledge

[arungoogol]

You are not hell, you are heaven!

[nerijusmikolaitis]

I love you man! You are so good at explaining this! I learned a lot. Very clear!

[ExcelisHell]

Thanks! Glad I could help :)

[dinakarpramod]

hey ur amazin i learned how to find but could u pls tell me how to a find a word and immediately bold it in macro it would be very great of u if u could tell again ur awesome keep goin mate

[ExcelisHell]

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

[freid001]

how do i apply this in to a form command button which looks at text feild in the form where user can type content to find?

[ExcelisHell]

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.

[freid001]

Yep thanks I have managed to work it out thanks good vid.