I am just starting out with VBA in Excel 2013

My first project is to create a button that will mimic the MS Excel find and find next function in a workbook.  I have created a button in my column labels row that will follow the user as they scroll down the page.  I tried to start the code with a macro to search, but it comes up blank.

Can you help me?  (I thought this would be much easier to begin with, NOT!)
Thanks,
Kim
Kim DygertAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamSkanRetiredCommented:
Can you post your macro code, please?
0
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorCommented:
What exactly do you want to archive , please try to be clear here, for example your macro you have written what is its objectives ??????????
0
Kim DygertAuthor Commented:
Sub Search()
'
' Search Macro
'

'
End Sub
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

GrahamSkanRetiredCommented:
It doesn't do anything.
In Excel and Word you can get started by recording a macro (Developer tab, Record Macro). The code so produced should work, though the style and readability could be better.
If should give you some code to work on and adapt to your exact requirements.
0
Kim DygertAuthor Commented:
That was produced  by recording a macro and I went to edit the code and that's all that was in there.  When I recorded the macro, I typed in the User Input Box for criteria and that too does not show in the code.  

I found code online that was able to bring up the User Input Box, but if there are numerous instances of the criteria, you would have to click, enter criteria, click button again, type criteria again, etc.  I am looking to open that search dialog box and type once, then click find again, to bring up the next instance until canceled by user.   I won't be able to attach that code until I get home.  

I was hoping to record the macro looking for criteria multiple times and edit code to enter user input box, but again, the code above was all that came of my recording.  Any thoughts?
0
GrahamSkanRetiredCommented:
This macro will display the Find dialogue repeatedly until cancelled
Sub Search
    Application.Dialogs(xlDialogFormulaFind).Show
End Sub

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kim DygertAuthor Commented:
Thank you so much for your help :)   I guess I complicated the issue in my head.  I cannot believe just one line did all that!  Happy Holidays to you and yours!!  Kim
0
Kim DygertAuthor Commented:
Your help was instrumental as I try to apply what I am learning.... quick and on point.  Thank you so much!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VBA

From novice to tech pro — start learning today.