+ Reply to Thread
Results 1 to 4 of 4

combobox replace files

  1. #1
    Registered User
    Join Date
    05-13-2015
    Location
    zoetermeer (nl)
    MS-Off Ver
    office 2007
    Posts
    20

    combobox replace files

    i am create a file but i havent the knoullidge so for in vba (my english is not so good on the paper, i am sorry for that).
    i am from the netherlands

    i knew a little bit of vba in excel.

    this is my problem.
    what i want is in dropbox(article number) select, so i can see in textbox(discription) wich product in textbox(from) and textbox(old) (the yellow color)
    the combobox replace (blue color) and then when i press the confirm button it replaced on the place of the red color.

    i sent de example of the excel on

    i hope i find the answer.
    Attached Files Attached Files
    Last edited by kdelange; 05-16-2015 at 03:12 PM.

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: combobox replace files

    Hi kdelange

    Welcome to the Forum!!!

    It's not clear to me where you wish the Output to go; try the Code in the attached.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    05-13-2015
    Location
    zoetermeer (nl)
    MS-Off Ver
    office 2007
    Posts
    20

    Re: combobox replace files

    thank you so far, its a first start for a big information inventory on my work

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: combobox replace files

    You're welcome...glad I could help.

    If this resolves your issue please mark your Thread as SOLVED.

    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:
    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. combobox with links to other files
    By TJ_IE in forum Excel General
    Replies: 0
    Last Post: 10-01-2014, 07:12 PM
  2. [SOLVED] populate combobox with files from folder but only excel files
    By jed38 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-30-2013, 02:31 PM
  3. Combobox search and replace a cell value
    By manforeyes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2012, 11:11 PM
  4. Re: Replace cells with selection from ComboBox
    By g00glethis1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-21-2010, 01:03 PM
  5. copy subfolders, replace text in files and save files in copied subfolders
    By pieros in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2005, 09:05 AM

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