+ Reply to Thread
Results 1 to 2 of 2

Insert data from userform

  1. #1
    Registered User
    Join Date
    08-21-2013
    Location
    Birmingham
    MS-Off Ver
    Excel 2003
    Posts
    25

    Insert data from userform

    Hi

    I am using a basic userform where I extract details into the userform from sheet 1 using a lookup function. I am now unsure how to proceed with if I want to overwrite found data and replace in the same cells that the information was found in.
    The code I am using to find the data is:

    Please Login or Register  to view this content.
    Once the userform has found the data, if I overtype in the userform I need the overtyping to populate the cells it has been found in

    Any help gratefully appreciated

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Insert data from userform

    Check out the code I provided in your other post http://www.excelforum.com/showthread.php?t=1152222
    You can just reverse the code to put values from TextBoxes to worksheet.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. Insert New Row with Data from Userform
    By stephenanderson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2016, 08:25 PM
  2. [SOLVED] Help! Userform VBA to find data in cell and insert into 2 cells over to right.
    By MG3 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-13-2015, 11:52 AM
  3. Insert row to existing table from userform data macro
    By akhalifa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2013, 12:23 AM
  4. How can I create a mask (Userform) to insert data?
    By balsilo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2013, 04:16 PM
  5. Userform insert data on the last row even when autofilter is active
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-29-2009, 02:24 PM
  6. Insert column Autofill using userform and then copy data from two spreadsheets
    By rm7302 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2009, 03:31 PM
  7. Insert UserForm Data in Named Range
    By Patchworks in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2009, 10:50 PM

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