+ Reply to Thread
Results 1 to 3 of 3

Update and delete entry in Datasheet via Userform

  1. #1
    Registered User
    Join Date
    03-03-2012
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    8

    Update and delete entry in Datasheet via Userform

    Hi,

    I have a userform for entering new data in to a data sheet. This userform also has a listbox with items already listed in the sheet. Basically it is divided into two frames whith the form with all the input boxes in the frame to the left (see below). The user can either add completely new data or pick one from the list as a "template" or so and ammend.
    There are two remaining issues that I am struggeling with:
    1. How to choose an item from the list and update it so that it replaces the excisting data.
    2. How to delete an item - in other words blank out the data for this entry.

    Help is much appreciated.

    Userform.jpg

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Update and delete entry in Datasheet via Userform

    Hi

    Upload your file...
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Registered User
    Join Date
    03-03-2012
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Update and delete entry in Datasheet via Userform

    Here you go...
    Book1.xlsm

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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