+ Reply to Thread
Results 1 to 3 of 3

How to get data from text box to code

  1. #1
    Registered User
    Join Date
    07-19-2014
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    18

    How to get data from text box to code

    Its been 3 days im trying to use vba for excel. However after lot of struggle i was able to make user form in which i enter data in textbox1 it searches from the sheets and puts the data in the rest of text boxes
    On the other hand i made a code which makes a word document basically a notice. Which uses data such as names and ids from cells but now i want to mix both. As now i want is that if i search using the user-form i want to add one more button to that same user-box which executes data from that user form to put values on notice
    Im a newbie i used youtube And forums

  2. #2
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: How to get data from text box to code

    Hi,

    Please share what you have done and on the basis of that I could comment. Also, mention in the excel the functional flow of your code.

    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

  3. #3
    Registered User
    Join Date
    07-19-2014
    Location
    Malaysia
    MS-Off Ver
    2013
    Posts
    18

    Re: How to get data from text box to code

    This Code is for my userform
    Please Login or Register  to view this content.
    This is the code for my user form sa.PNG


    this code is for my module which launches the word file
    Please Login or Register  to view this content.
    now what i want is that commandbutton one which launches the code "lockersusingcreatobject"
    use the values from textbox1,textbox2 and TEXTBOX3. aS i dim FTW from sheets i want to dim Ftw and use it from the textbox instead of he sheet.
    please reply Thanks

+ 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. [SOLVED] Code to verify text box contains data.
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 12-26-2013, 11:19 PM
  2. Help modify the VB Code to copy data between 2 text string
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-25-2013, 11:08 AM
  3. Vba code to output the text box containing selected data with comma.
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-29-2013, 09:13 AM
  4. [SOLVED] Code to enter caption text for labelControl or code to activate textboxControl text
    By JasonRay in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-14-2013, 05:42 PM
  5. [SOLVED] Code to input data from a text box into a workbook
    By Chatters in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-26-2013, 09:19 AM

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