Creating a Search Engine in Excel

Hey.

Are You familiar with making user forms?
Would the attached work?
If you right click on the Sheet name and click, view Code - then look a the user form code by right clicking the userform title FrmSearchDatabase and clicking View code.
You should just be able to change this to what you need?

This was a response to one of my previous queries, which I have slightly amended to suit your requirements.
(Original design of the attached form was by another user on a different forum)

No sweat.
I just thought I would post this in case it helped solve what you needed, as it helped me out before.

I must point out, I'm not one of the Guru's on here, purely a loyal user learning the ways of the masters.
Unfortunately, Whilst I am sure it will be possible to search across multiple sheets and with more than one category selection, it will take one of our very helpful Gurus to help us out with how to do it.... (now hoping for one of said Gurus to chip in and rescue me...)

Good luck, and please post your results on here, even if the answer doesn't come from here, that way the information will be available for other users to see if they have a similar query and wind up looking here...

Hi Richard,

Good job with your VBA. I've add a For Next Loop to do all sheets. See the code added (only a few lines) in the attached.

Originally Posted by MarvinP

Hi Richard,

Good job with your VBA. I've add a For Next Loop to do all sheets. See the code added (only a few lines) in the attached.

Hey Marvin, Thanks for the input, that's great! I think this resolves that part of the problem, any idea's on the ability to use multiple categories, for example, I presume Tooooon might want to search 'Name' and 'Status' to find out which courses Barry has completed, maybe?

Toooon, what exactly do you need here? - the more detail you add, the more accurate your responses will be....

(My reply might duplicate, because I posted, and it didn't show up, so I did it again!)


KR