+ Reply to Thread
Results 1 to 6 of 6

Updating data vba

  1. #1
    Registered User
    Join Date
    06-11-2011
    Location
    south africa
    MS-Off Ver
    Excel 2007
    Posts
    26

    Updating data vba

    Good day, I have a userform with updates data to a spreadsheet worksheet 2 - when you click a button to bring up the form it has a combo box and a few text boxes that have info in and some need info - what I am try to do - once you click on the combo box it brings up a surname, then the other text boxes bring up some info (to verify the correct surname) I need one of the text boxes info to be sent across to the relevant row and column. There are two that need that info sent. Those two will always go to the same surname in a column. Then there are three more text boxes that require info from the user, that info needs to be sent across too, however that needs to go to same surname (row) but update across as you update the info.
    Any help would be appreciated.
    Last edited by Quintin; 10-08-2014 at 08:38 AM.

  2. #2
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Re: Updating data vba

    Hi there!

    Can you upload the xls file? Eventually with some explications in it?
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  3. #3
    Registered User
    Join Date
    06-11-2011
    Location
    south africa
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Updating data vba

    I tried to upload it and i received a message saying, "file to big" could maybe email the file to you.
    Thanking you

  4. #4
    Registered User
    Join Date
    06-11-2011
    Location
    south africa
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Updating data vba

    Oh it's 4mb

  5. #5
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    867

    Re: Updating data vba

    I've sent you my email address in a PM

  6. #6
    Registered User
    Join Date
    06-11-2011
    Location
    south africa
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Updating data vba

    Thank You to bulina2k for assisting me with this problem - Solved

+ 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. Updating data from a main list after data has been split into smaller lists using VBA
    By lukeafuller in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2014, 03:22 AM
  2. Replies: 1
    Last Post: 05-14-2014, 08:24 AM
  3. Pivot Tables and VBA: Changing Contents in Data Area and updating the Data Source
    By kyrgyzstanart in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2011, 11:11 AM
  4. Duplication data every time macro is run, instead of updating newly found data only
    By Lostinxcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2010, 03:41 AM
  5. Replies: 0
    Last Post: 12-05-2008, 01:32 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