Search for data in another workbook and show in current workbook listbox.

Rilode

New Member
Joined
Feb 10, 2021
Messages
1
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
for my company I'm making a user form to make things easier for my colleague's.
now i have create a userform to make several word documents and store them in a excel database

but now I want to search in a exist database and show the results of the search in a listbox in the workbook I have create.
so how can we achieve that

I want to search trough the database on three terms but not necessary to fill in al the 3 terms.
I search for doorcilinders and the terms I want to search are Cilindername, building and roomnumber

so I create a userform with 3 textboxes and a search button and below that a listbox to show the results

but which codes I need to let the button really search for the ask features in the boxes in the other workbook.

I understand that the other work book has to be opened so if the code also can do that in the background, because its not an option that everybody can enter the exist database but just can get some information out of it.

greetings
Rieko
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,127,387
Messages
5,624,402
Members
416,026
Latest member
melvic69

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top