+ Reply to Thread
Results 1 to 4 of 4

preview image in UserForm

  1. #1
    Registered User
    Join Date
    07-27-2010
    Location
    Asia
    MS-Off Ver
    Excel 2003
    Posts
    2

    preview image in UserForm

    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?

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    re: preview image in UserForm

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: preview image in UserForm

    I've editeds the Title this time.

    See the databaseForm example here

  4. #4
    Registered User
    Join Date
    07-27-2010
    Location
    Asia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: preview image in UserForm

    Sorry for not following the rules. Anyway thanks for the help..wow!! its really help me! Thanks a lot!! :D
    Last edited by no_3belas; 07-27-2010 at 08:40 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1