Results 1 to 4 of 4

Entering data with UserForm in to Sheet2

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-29-2006
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    314

    Entering data with UserForm in to Sheet2

    Dear all
    I m trying to enter data with a UserForm on excel sheet. My aim is the data will be entered on to Sheet2 and by using VLookUp function the data will be transferred to Sheet1 so that the Sheet2 data will be safe when I refresh the Sheet1.
    I have prepared the form on the attached excel file it will auto load when you open the file.

    Can you please help me with writing these 2 buttons codes at below?

    Accept – I like to use this button to enter the invoice number to the Sheet2 (under the Invoice Colum in to A2 cell) and the Notes text to the Sheet 2 (under the Notes Column B2 cell) , and next entries following down from the A2 cell and the B2 cell.

    Delete – I like to delete entire row


    thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Userform (for Entering Data)
    By Faraei in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-22-2014, 10:48 AM
  2. [SOLVED] copy over data from userform to sheet2
    By mak_pj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-26-2013, 05:52 PM
  3. [SOLVED] Refresh UserForm after entering data in another userform
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-30-2013, 10:34 AM
  4. Need help entering in data from userform
    By adamjohnson182 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2013, 08:15 PM
  5. Entering data from a Userform into a row
    By dougwild in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-18-2012, 10:52 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