getting results from 4 combobox selection to three text boxs in useform

[Anchal]

Hello All,

My data resides in a workbook in sheet2 and sheet3. I have 4 comboboxs refereing to different columns in sheet2 and sheet3. Basically when the user selects all the four comboboxs, the criteria should be satisfied and the results in terms of rows matching those values should be shown in the textboxs below.

Each three of the textboxs refers to individual columns in sheet2 and sheet3. All I want to do is simple search criteria on both sheet 2 and sheet3 and put the results in textboxs...any help please... dont know where to start with..

I have populated my comboboxs but dont know the macro to do the search results .

[tehneXus]

Hi Anchal,

could you provide the userform and data tables in an example workbook?

Regards

[Anchal]

Hello tehneXus

my excel,where sheet1 has form with 4 comboboxs and below the pop up details button their is 3 comboboxs( since I didnt know how to put data from combobox to textbox...I put a combobox here )

combobox1 = sheet2 column C
combobox2 = sheet2 column BL
combobox3 = sheet3 column K
combobox1 = sheet3 column F

The results which satisfy the above 4 criteria should come from ,when user presses POP UP DETAILS BUTTON,

textbox1= sheet3 column C
textbox2= sheet3 column N
textbox3= sheet2 column T

Actually I have many records which satisfy the above 4 criteria, dont know how to display them whether in textbox or any another method... please help ........

Their is some problem with the upload , I cannot upload any excel file sorry!!

[Anchal]

dear tehneXus,

I somehow managed to attach the file please have a look and help ...