Home > Open Source Technology > Search function in VBA/Excel
Open Source Technology
Search function in VBA/Excel
On August 04,2022 by Tom RoutleyI 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.
Article Recommendations
Latest articles
Popular Articles
Archives
- April 2024
- March 2024
- February 2024
- January 2024
- December 2023
- November 2023
- October 2023
- September 2023
- August 2023
- July 2023
- June 2023
- May 2023
- April 2023
- March 2023
- February 2023
- January 2023
- December 2022
- November 2022
- October 2022
- September 2022
- August 2022
- July 2022
- June 2022
- May 2022
- April 2022
- March 2022
- February 2022
- January 2022
- December 2021
- November 2021
- October 2021
- September 2021
- August 2021
- July 2021
- January 2021
Leave a Reply