Home > Open Source Technology > Search function in VBA/Excel
Open Source Technology

Search function in VBA/Excel

On August 04,2022 by

I try to make a macro that looks for a value in a database and that copies data in two columns after the reference.

example:

database: PS85 ps86 ps77 ps52 ...

PS85 ps86 5 ps77 ps52 ...

Solution

Try this code: ComboBox1 = droplist with value (ps85, ps86 ...) ComboBox2 = Quantity list CommandButton1 = The submit button

Adapt the following code:

Thanks to pijaku for this tip.

Leave a Reply

Your email address will not be published. Required fields are marked *