+ Reply to Thread
Results 1 to 5 of 5

excel vba codes to automate data entry in excel

  1. #1
    Registered User
    Join Date
    08-30-2013
    Location
    manila
    MS-Off Ver
    Excel 2007
    Posts
    3

    excel vba codes to automate data entry in excel

    Hi Guys,

    I need codes to help me with data entry in excel. I created sheet 1 as a user form for data entry and I want sheet 2 as the storage for the data entered. Ideally, I need the data to be automatically added to sheet 2 once I click on the submit command button and the textboxes to be automatically cleared on the user form.

    Is this something possible? If you guys can post some codes for me it would really help. Im new with this Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: excel vba codes to automate data entry in excel

    This is very easily done.

    Are your inputs Textboxes? Comboboxes? ListBoxes?

    The best idea is to create your textboxes sequentially so you can tab between them in sequence.

    Then you can use a loop to save your text boxes rather than saving each in turn.

    If there is a lot of data, Read your userform data into an array and save that array to excel
    This will speed up your data entry quite dramatically.

    I'll post some code to show you how to save your Userform.

    Please note i use the first Line of My DataSheet as the default text for my userforms.

    Ex TextBox 1 contains "First Name" until you click on it at which point my textbox enter event clears it, but is you save the entry without changing the first name,
    textbox1 will have the same text as cell A1 I " First Name" and so I do not save it.


    Please Login or Register  to view this content.

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: excel vba codes to automate data entry in excel

    Hi, hyouenaye,

    have you had a look at the Data Mask which needs to be put into the QAT from Excel2007 on through Excel Options?

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Registered User
    Join Date
    08-30-2013
    Location
    manila
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: excel vba codes to automate data entry in excel

    Hello. My inputs are a combination of textbox, combobox and radio buttons. Thank you for this the codes are kinda complex. Im not sure Im getting it but I'll try to apply it. Thanks again

  5. #5
    Registered User
    Join Date
    08-30-2013
    Location
    manila
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: excel vba codes to automate data entry in excel

    Hello Im not familiar with data mask. what is it for? Sory newbie here.

+ 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. Automate excel internet data?
    By fruitofphysics in forum Excel General
    Replies: 0
    Last Post: 09-21-2009, 08:17 PM
  2. Automate data entry from single cell reference!
    By Spellbound in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2009, 08:36 AM
  3. automate data collection in excel
    By startstop in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-11-2009, 09:45 PM
  4. automate data entry by linking data
    By jcavigli in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2008, 01:48 AM
  5. [SOLVED] HOW CAN I CONVERT EXCEL DATA TO BAR CODES?
    By guyinrenton in forum Excel General
    Replies: 1
    Last Post: 09-14-2005, 02:06 PM

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