+ Reply to Thread
Results 1 to 5 of 5

Code to input data from a text box into a workbook

  1. #1
    Registered User
    Join Date
    01-22-2013
    Location
    Eastleigh, England
    MS-Off Ver
    Excel 2007
    Posts
    14

    Question Code to input data from a text box into a workbook

    I'm want to build a graphical user interface to enable data entry to be made easier at work. I will probably be able to work out everything I need after finding out the first bit.

    Basically I'm just looking for how to input data from a text box on a gui into a cell in a different workbook when the user clicks an add button.

    If somebody could give me an example of this code then I think I'd be able to do most of the database.
    Karl Fellbrich

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Code to input data from a text box into a workbook

    here's a great guide on user forms, you can modify the code to put the input data into a different workbook, I would put together an example, but it takes a while for me since i'm still new at forms

    http://www.fontstuff.com/ebooks/free/fsUserForms.pdf


    attached is an example workbook with a form that i made from the instruction from the link above
    user form test.xlsm

  3. #3
    Valued Forum Contributor smuzoen's Avatar
    Join Date
    10-28-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    610

    Re: Code to input data from a text box into a workbook

    This is very basic but it may get you started - I have attached a workbook for you. You will need to have the second workbook open to have the value entered.
    Please Login or Register  to view this content.
    This code can be behind a button on a Userform so when the user hits the button the value is entered into the workbook called ReceivingWorkbook. As I said previously this workbook needs to be open. For it to be robust you really should programmatically check if the workbook is open and if not then open the workbook. As I say this is very basic but will get you going.
    Attached Files Attached Files
    Hope this helps.
    Anthony
    Pack my box with five dozen liquor jugs
    PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?

  4. #4
    Registered User
    Join Date
    01-22-2013
    Location
    Eastleigh, England
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Code to input data from a text box into a workbook

    Many thanks
    I will have a look and see what I can do.

  5. #5
    Registered User
    Join Date
    01-22-2013
    Location
    Eastleigh, England
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Code to input data from a text box into a workbook

    Thanks for this, its much appreciated

+ 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