+ Reply to Thread
Results 1 to 4 of 4

Modify userform textbox data validation to include text instead of just integers

  1. #1
    Registered User
    Join Date
    09-04-2014
    Location
    Austin, Texas
    MS-Off Ver
    2010
    Posts
    36

    Modify userform textbox data validation to include text instead of just integers

    Hi all,

    I found some VBA code that allows viewing/editing cell values that are linked to textboxes in a userform. The cell values are displayed in multiple userform textboxes based on an integer. Example, when a user inputs an integer that is valid, a corresponding set of textboxes are populated with data unique to that integer. What I want to accomplish is to allow a user to choose a string value from a combo box on the userform that will then populate the textboxes in the userform with the corresponding data values from the spreadsheet. I've attached the code.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Modify userform textbox data validation to include text instead of just integers

    Just use Range Find in the combobox change event to populate the textboxes.

    Can you provide a sample workbook with sample data? Select a item in your sample set and explain your expected results.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    09-04-2014
    Location
    Austin, Texas
    MS-Off Ver
    2010
    Posts
    36

    Re: Modify userform textbox data validation to include text instead of just integers

    9-25-2014 3-32-23 PM.jpgSee if the attachments make sense...
    Attached Files Attached Files
    Last edited by karmadog62; 09-25-2014 at 04:47 PM. Reason: Pic not showing

  4. #4
    Registered User
    Join Date
    09-04-2014
    Location
    Austin, Texas
    MS-Off Ver
    2010
    Posts
    36

    Re: Modify userform textbox data validation to include text instead of just integers

    trying as a pdf this time
    Attached Files Attached Files

+ 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. Modify userform textbox data validation to include text instead of just integers
    By karmadog62 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-23-2014, 12:06 PM
  2. VBA Userform - Restrict Text Box to integers between 18 - 80
    By kamelkid2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2013, 03:38 PM
  3. Data Validation in textbox on userform
    By nav505 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2013, 08:02 PM
  4. Data Validation in textbox on userform
    By nav505 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2013, 07:37 PM
  5. Data validation in TextBox on UserForm
    By tim_chisman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2010, 09:33 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