+ Reply to Thread
Results 1 to 3 of 3

Cell lookup and edit via userform

  1. #1
    Registered User
    Join Date
    11-29-2012
    Location
    Oxford
    MS-Off Ver
    Excel 2016
    Posts
    8

    Cell lookup and edit via userform

    Hi, I have basic knowledge of VBA and wanted to create a userform that looks up a product from one cell and edits a cell in the same row based on the userform input. This is what I have at the moment:

    Example.jpg

    I would like to be able to select a stock then add or remove volume so that it increases or decreases the value in the current stock column based on the value entered in the user form. Any help would be greatly appreciated.

    Test.xlsm

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Cell lookup and edit via userform

    For the Add

    Please Login or Register  to view this content.

    For the Use

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-29-2012
    Location
    Oxford
    MS-Off Ver
    Excel 2016
    Posts
    8

    Re: Cell lookup and edit via userform

    Thanks this is perfect!

+ 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. [SOLVED] Lookup/Search/Find/Match then edit in userform
    By Cuba64 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 12-17-2013, 06:49 PM
  2. [SOLVED] Userform text box to display and edit a single cell only
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 11-25-2013, 08:50 AM
  3. [SOLVED] Populate cell values into 6 named text boxes in a userform then edit if required
    By How How in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-05-2013, 05:51 AM
  4. Dynamically updating userform that lists worksheets and allows to edit one cell
    By bujaman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2010, 02:16 PM
  5. edit the existing userform
    By barishta in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2009, 01:36 PM
  6. [SOLVED] only edit from userform
    By mg_sv_r in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2006, 09:10 AM
  7. [SOLVED] Vlookup doesn't work until i edit(but not change) the lookup cell
    By Confused in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-08-2005, 05:25 AM

Tags for this Thread

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