+ Reply to Thread
Results 1 to 3 of 3

Find and replace data using using existing userform?

  1. #1
    Registered User
    Join Date
    10-09-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2003
    Posts
    20

    Find and replace data using using existing userform?

    Hi all.

    I have a userform which enters several entries on to two spreadsheets (dependant on a checkbox on the form)

    If the entries are to be changed I wanted to use the same userform to replace the entries on the worksheet- What I need is VBA code to check the customer's account number is already present, then overwrite the entries on the worksheets thus replacing the original data. Is this possible? Im sure it is but I'm not sure how to do it. Any help greatfully accepted.

    Ideally I would also like a way of users checking if an entry already exists on the worksheets. The workbook currently has a front sheet with a macro box to bring up the userform. The data sheets are hidden to stop the data being tempered with.

    Is there a way that if the account number could be input on the front page and then the data could be retrieved and displayed on the front page? Also namechecking the name of the sheet

    Any help on these two issues would really be great.

    Many thanks in advance.

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: Find and replace data using using existing userform?

    Hi

    all the things you have asked for can be done but you need to make up your mind how exactly you want it to work.

    Also you need to attach the spreadsheet so that we can see what you are talking about.

    In the meantime this thread covers much of what you are asking for. http://www.excelforum.com/excel-prog...ml#post2259102



    click on the * Add Reputation if this was useful or entertaining.

  3. #3
    Registered User
    Join Date
    10-09-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Find and replace data using using existing userform?

    Tony - Many thanks for your reply.

    I have attached the sheet as requested.

    Ideally- I want to keep the sheets 'Same term' and 'Extended term; to be hidden.

    If a cell on 'Reschedules' could be used to enter the account number -this would trigger the data being returned on the same page.

    Then if the account is already on the worksheets the user could then input the details on the same form and they would be replaced on the worksheets. I hope this makes sense.

    PLease excuse the appearance of the sheet- it is the last thing i will sort.

    If you could help with this I would really appreciate it.
    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)

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