+ Reply to Thread
Results 1 to 2 of 2

Code Textbox (lstMyData) to match row data in wroksheet and block all other rows from edit

  1. #1
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Code Textbox (lstMyData) to match row data in wroksheet and block all other rows from edit

    Hi,

    This may be a challenge... I have attached the Workbook for review.

    I have created a splash screen and when the User enters their username and password they are taken to their data sheet - example inside this Workbook (JohnFletcher_Stats) . I would like the user to update their own records at the end of each day of their stats into the Userform. When the user selects the update button, it opens the Userform, I want the Textbox (lstMyData) to locate and match the data in the sheet (JohnFletcher_Stats) Range and Rows within this sheet and block the User from modifying or updating any other Users data in the Userform (textbox- lstMyData)

    Is This Possible

    To access the Workbook:
    Username = B
    Password = 2

    To Access the Userform from withing the sheet - JohnFletcher_Stats:

  2. #2
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    985

    Re: Code Textbox (lstMyData) to match row data in wroksheet and block all other rows from

    this post is an error I d not know how to remove it sorry!
    Last edited by JJFletcher; 11-13-2014 at 06:24 PM. Reason: not supposed to be posted - error

+ 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. Replies: 9
    Last Post: 05-24-2013, 01:31 PM
  2. Delete rows if values match in a block of cells
    By Premangshu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-21-2012, 05:47 AM
  3. Edit Sheet1 data by using User Form Textbox
    By lapot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2012, 04:27 AM
  4. Edit existing data in spreadsheet through userform textbox
    By MIFF3436 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-04-2012, 12:17 PM
  5. data form to browse & edit, with multiline textbox
    By SarahMcM in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-26-2006, 08:16 PM

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