Use VBA and UserForm for Search in Excel Sheet (Like Ctrl+F)

[zeko90]

Hi to all

I think the title describe all, but anyway. It's possible to do UserForm like function Ctrl+F for search in Excel sheet. Yes i know that is a little silly question but it will be cool if this possible
I have already work with macros, not some big one. Maybe if some one have starting point or better practical example.

Nice day ahead to all !

[nathansav]

I'd investigate the UserForm in Excel and look at the Find VBA class, using the help. Why you want to reinvent the wheel?

[zeko90]

you're write. It is just for visualization. I want put search field above the table for quick search (most for amateurs users). Sorry i don't understand you first sentice very well, is possible to do it or not ?

Thank you!

[nathansav]

So you want a text box on your worksheet for searching, not to redesign the search form?

[zeko90]

exactly

[nathansav]

Your post is misleading then.

You need to have the VBA find function


Range(Range("a:a").Find(TextBox1.Value, Cells(1, 1), xlValues, XlLookAt.xlPart, , xlNext, False).Address).Select


using TextBox1.Value for example as what to look for.

[zeko90]

Yes i think u are right,

But this is great is just that what i was looking for Can you please just help me to make without textbox (textbox will be cell (A1 Example)). best will be on practical example.

Thank you!

[nathansav]

Range(Range("a:a").Find(range("a1").Value, Cells(1, 1), xlValues, XlLookAt.xlPart, , xlNext, False).Address).Select

[zeko90]

Work great! Thank you! but i have one more question why not work if i change Range ("a:a") to example Range ("c:c") ?
And can you please help me write if statement if noting if found than display bsgbox?

[apo]

Hi..

Here's one I made a while ago..

In the Attached Workbook.. Press CTRL + s to run the Sub...

Please Login or Register  to view this content.