search engine and macro vba

[eliking510]

Hey, I have the foloowing Problem, i need help.

In the first userform when choosing the company , the text typed in the textbox will be copied into another sheet according to the company name ( for each company there is a diffrent sheet )

Here comes my prob: I only created the design mode for the second userform.
I need to search using one or more parametres and the input the results into the third userform.


Its very complicated to me, I am just a beginner.and i will be greatfull if i can get a clear explanation with some steps to follow

Thanks for helping

 

[pedie]

Not sure what you want but why do you have to use 3 userforms. Use 1 userform then use Combobox or textbox for critirias and then you may also display your result in different page by using MultiPage.

How does your code look like now?

 

[eliking510]

Not sure what you want but why do you have to use 3 userforms. Use 1 userform then use Combobox or textbox for critirias and then you may also display your result in different page by using MultiPage.

How does your code look like now?

I will have two optins.. 1- input a new value. 2- search

the first userform is for adding new values...the second userform is to search for the values i've been added .. and by clicking "search".. the result will be displayed in a new windows.. now when im thinking.. the third userform is useless.

Here is an example that may help you
-------------------------------------
company- 1
Car- X
color- blue
Type - 4X4
(this will be saved in the "1" sheet)
and anoother one

company- 2
Car- X
color- red
Type - 4X4
(this will be saved in the "2" sheet)

Now.. I want to search for all the 4x4 type and with a blue color( in both companys)or to search for all the Red cars, and to display the results in a new windows,

I hope it was clear enought ,Thanks for helping