Hi there, I'm new to the forum and to a total noob in VBA.
I'm in the middle of making a parts catalog using UserForm & excel as database. Now I'm stuck at the level to preview the image inside the userform.
The whole process is like this:
1. I've created a database which included the part number, price, description & location in excel.
2. Then I design a userform that includes all the particular that I mentioned above and a search button.
3. So whenever I typed the part number in the search box & click search, it will display all the data in the database.
My questions is:
1. How can I preview an image of each parts inside the userform as a search result? I've stored all the image inside a folder in my computer. All the image have been rename accordingly to its part number.
2. How to execute the search button by hitting enter button?
Bookmarks