MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Searching while in an excel userform

  Asked By: Bastet    Date: Oct 10    Category: MS Office    Views: 1284

I've been gone working on my user form for a while now... I am at the
point where I have the form the way I want it... it captures the data I
need and in the format required.

I now would like to add an additional item for user function...
Specifically, I want to add a search feature, accessed from either a
command button or a toolbar on the form... I don't know how to do
either, but assume it can be done...

I would appreciate feedback on which is easiest/most user friendly and
advice on how to get started...



1 Answer Found

Answer #1    Answered By: Levi Wilson     Answered On: Oct 10

One approach is:

Record a macro while you do a search  in the spreadsheet or workbook.
Edit that macro to use parameters where you want the user  to be able to
specify what is being searched for.
If you want a complex search you may need to create a userform  to allow the
user to select/specify parameters and search terms
Test your search macro/search form.
Put a button  on the main form  and make its click event call the macro/search

Didn't find what you were looking for? Find more on Searching while in an excel userform Or get search suggestion and latest updates.