+ Reply to Thread
Results 1 to 4 of 4

Finding and editing data in a worksheet

  1. #1
    Registered User
    Join Date
    06-06-2006
    MS-Off Ver
    2010, 365
    Posts
    39

    Finding and editing data in a worksheet

    Hi,

    I am making this application in VBA which requires me to Find data from a worksheet and display in a userform for editing. Then, writing the edited data from the userform back into the worksheet in the same row where the data was picked from. The problems that I am facing are:

    1. There can be repeated data for the Find criteria. I need to pick up the last data entered into the worksheet.

    2. Once the data is updated, it needs to be entered into the same row where it was picked up from.

    Please help.

    Peace,

    Shivboy

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    can you attach an example with what you have so far?
    Hope that helps.

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

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    06-06-2006
    MS-Off Ver
    2010, 365
    Posts
    39
    Nothing, really. I am supposed to be working on it from end of this month. Throw some ideas on how to go about it, if you have any.

    Thanks,

    Shivboy

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Take a look at my DatabaseForm example

    http://www.excel-it.com/vba_examples.htm

+ 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