+ Reply to Thread
Results 1 to 3 of 3

Run code when values are entered in userform textbox?

  1. #1
    Forum Contributor
    Join Date
    10-06-2015
    Location
    Leeds, England
    MS-Off Ver
    365 Version 2202 Build 16.0.14931.21078
    Posts
    127

    Run code when values are entered in userform textbox?

    I have created a userform used to populate and edit a spreadsheet for a chosen ID number in Column A. I have a button which looks up the other columns for the given ID number and populates the information in the textboxes on the form, these can then be edited and saved. Is it possible to have a sort of live or interactive textbox, when I start typing the ID number it'll automatically run off code to populate the text boxes if the information is I the spreadsheet?

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Run code when values are entered in userform textbox?

    Would help if you can upload an example workbook with the layout of you data structure.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Run code when values are entered in userform textbox?

    textbox Change event with your code to populate userform

+ 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] Updating text in shape using data entered in a textbox in userform.
    By Awni in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-23-2016, 06:48 AM
  2. VBA code to return 2 vlookup values into 1 textbox on userform
    By gemnnsw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2016, 10:52 AM
  3. Restrict the value entered into a textbox on a userform
    By D.Lovell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2015, 05:30 PM
  4. [SOLVED] Search column for entered value and return results to textbox in userform
    By MIFF3436 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2015, 06:35 AM
  5. Userform to search textbox value to place other textbox values in worksheet
    By mattyh555 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2012, 11:38 AM
  6. [SOLVED] show message box when a duplicate entry is entered into a userform textbox
    By reggie1000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2012, 05:53 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