+ Reply to Thread
Results 1 to 2 of 2

Editting Data in a table using a userform

  1. #1
    Registered User
    Join Date
    05-10-2015
    Location
    Ryton
    MS-Off Ver
    Office 2013
    Posts
    49

    Editting Data in a table using a userform

    Hi All

    I have a small problem with a table which when a name needs changing the userform only only edits the first entry and stops whithout changing all the same names in the column

    The code I am using is below

    Please Login or Register  to view this content.
    The problem lies in the sheet 6 part of the code

    is there a way of changing all of the same names from column C

    Regards Moose

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523

    Re: Editting Data in a table using a userform

    You would have to loop through each cell if you wanted to use match.

    Filter would be a lot quicker.

    Please Login or Register  to view this content.

+ 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. Userform to retreive data from one table and post data to another
    By marktreadwell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2015, 12:27 PM
  2. Replies: 3
    Last Post: 05-29-2012, 07:54 AM
  3. Pivot Table editting options
    By lpexcel in forum Excel General
    Replies: 3
    Last Post: 04-04-2012, 02:23 AM
  4. Editting Macro to Select Last Empty Column to Paste Data
    By Zaraf in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-05-2008, 11:40 AM
  5. 1 click editting
    By krayziez in forum Excel General
    Replies: 1
    Last Post: 06-11-2008, 12:48 PM
  6. macro editting
    By MINAL ZUNKE in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2005, 10:05 AM
  7. [SOLVED] Hexidecimal Editting
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-12-2005, 07:05 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