+ Reply to Thread
Results 1 to 2 of 2

How to select a row from a table based on txtbox value??

  1. #1
    Registered User
    Join Date
    12-09-2020
    Location
    australia
    MS-Off Ver
    2010
    Posts
    12

    How to select a row from a table based on txtbox value??

    Hi New to all this and having trouble writing a code to set a list row in a table from value in textbox.

    The idea is so I can edit rows without creating a new row all data being written to a table.

    Any help would be great thank you.


    Please Login or Register  to view this content.
    Last edited by AliGW; 12-20-2020 at 12:55 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,432

    Re: How to select a row from a table based on txtbox value??

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. As you are new, I have done it for you today.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them 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. [SOLVED] Check box if true copy txtbox 1 to txtbox 2
    By mmikem in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2019, 02:27 PM
  2. [SOLVED] Macro to select multiple pivot table filters, based on values in a table
    By Portuga in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-03-2018, 06:42 PM
  3. [SOLVED] Select value in table based on Gender and Weight
    By Thomas62 in forum Excel General
    Replies: 14
    Last Post: 10-19-2016, 09:56 AM
  4. Select a value based on a table of data
    By LeeGro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2014, 04:03 PM
  5. Creating a formula to select a value in a table based on a criteria
    By davidnyke in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-03-2014, 10:07 AM
  6. Select table rows based on is not blank
    By reillc01 in forum Excel General
    Replies: 0
    Last Post: 12-02-2010, 11:22 AM
  7. How do I select a value from a table based on 2 conditional refs?
    By Puzzled Percy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-14-2006, 11:45 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