+ Reply to Thread
Results 1 to 3 of 3

Need a macro which allows me to edit existing data to replace old data in same cells

  1. #1
    Forum Contributor
    Join Date
    10-03-2015
    Location
    Jamaica
    MS-Off Ver
    2013
    Posts
    120

    Need a macro which allows me to edit existing data to replace old data in same cells

    Good day all

    In the attached example (Which is a bare bones version of my project just for example purposes):

    I have created a UserForm which was designed to "look up" information from a worksheet. What I would like is a macro that will allow me to edit data using that same UserForm.

    So in examining my example (and I am not even sure if this is even possible) I would like a macro so that when I click the "edit" button, a password prompt appears where a password would be required to edit data (or something of that nature). Then once the data is edited, when the user clicks "update" the data is saved in the same positions/order it was previously saved under the same headings.

    It should be noted that I intend to use this function to also add data which I previously could not get at the time of initial input (i.e. I may input student data without the students grade and save, then at a later date, when the grade is ascertained, I use the aforementioned function to add the data).

    Any assistance/guidance re this matter would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-03-2015
    Location
    Jamaica
    MS-Off Ver
    2013
    Posts
    120

    Re: Need a macro which allows me to edit existing data to replace old data in same cells

    I have received some assistance re the password issue so I think I can go from there.

    As for the editing issue I have used variations of the following macro to populate the UserForm the the info I want to edit:

    .Box1 = Application.WorksheetFunction.VLookup(Me.Reg1, Range("LookUpStuInfo"), 2, 0)

    What I would like now is a macro that will save the edited info to the worksheet. If my colleagues examined the worksheet, you will see how the data is saved in the worksheet and more specifically (as apparently i don't think i am explaining myself properly)

  3. #3
    Forum Contributor
    Join Date
    10-03-2015
    Location
    Jamaica
    MS-Off Ver
    2013
    Posts
    120

    Re: Need a macro which allows me to edit existing data to replace old data in same cells

    As I already have a macro to search for data in the worksheet, all I need now is a macro to edit the data that the search produces.



    Just for reference purposes this is the macro i use to input data into he aforementioned work sheet

    Please Login or Register  to view this content.
    I have been trying to modify this code to edit data so the data overwrites previously saved data and remains in the same position it was in the work sheet.


    Again, ANY assistance will be greatly appreciated.
    Last edited by Pimp_mentality; 12-23-2015 at 12:25 AM.

+ 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. How can I change font color when I edit existing data?
    By indra in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-27-2016, 10:23 AM
  2. Userform Buttons to Delete or Edit existing data
    By rach3lmclark in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-17-2013, 11:53 AM
  3. [SOLVED] Macro to Find & Replace existing formula with text in referenced cells
    By sonyap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2013, 10:39 AM
  4. How to Edit Existing data of excel sheet
    By ashfaquebwd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2013, 09:24 AM
  5. Using VBA Userform to edit/amend existing data
    By Raporter65 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2013, 03:41 PM
  6. Edit existing data in spreadsheet through userform textbox
    By MIFF3436 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-04-2012, 12:17 PM
  7. Replace Existing Worksheets with New Data
    By aftabn10 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-28-2011, 08:24 AM
  8. Excel VBA Userform - Sets of data, View original, add new, edit existing
    By newzealdan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-27-2011, 03:54 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