• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 106
  • Last Modified:

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
0
Kim Dygert
Asked:
Kim Dygert
  • 4
  • 3
1 Solution
 
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now