[ExcelVBA] Finding Multiple Occurances

 

Hi all,
I have developed one form which is used to display all the information
that is stored in single row across different columns (single user at a
time of the row at which cursor is). I have also added search box and it
is able to find 1st occurrence of the search criteria from the
ActiveCell. However, I want to achieve the following:

* After Clicking the Search Button a message box will pop up
indicating number of occurrences of the search criteria in given range
(Assume Range to be "A5:A5000")
* Then apart from OK button on message box there should be two
additional buttons Next and Previous
* These buttons would help navigate the records found
Can anyone please help me with this
ThanksViraj

[Non-text portions of this message have been removed]

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 1

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___