+ Reply to Thread
Results 1 to 7 of 7

Vba update active row specific column

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

    Vba update active row specific column

    Good day I have a userform that i have put together - combobox for name and text boxes for other info, what I would like is when you call up a name you fill in some info, now on two of the text boxes i need that info to go to the same (active row) the one you're updating.
    thx

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,501

    Re: Vba update active row specific column

    Maybe something like:

    Please Login or Register  to view this content.
    Edit as required.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


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

    Re: Vba update active row specific column

    Thank you, just a question - when i run it with the F5 key it works, however when i run it from the userform submit button then it doesn't seem to work??? not sure if i placed it in the correct area...and i have got "unload.me at the bottom

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

    Re: Vba update active row specific column

    Okay i found it putting the data on the incorrect sheet...:-( now trying to get it to be placed on the correct sheet

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,501

    Re: Vba update active row specific column

    i need that info to go to the same (active row) the one you're updating.
    The Active Row exists on the Active Sheet which will probably be the one with the Text Boxes on it.

    You need to share your code and, ideally, a sample workbook in order to have a sensible dialogue about where things end up.

    Regards, TMS

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

    Re: Vba update active row specific column

    Would it be possible to email you the file, with an explanation of what i need/trying to do - the reason is the file is about 6mb

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,501

    Re: Vba update active row specific column

    You'd be better making a copy and removing everything but the bare essentials and uploading that.

    That way, more people can contribute.

    I don't offer private consultations. Well, I do, but you'd have to pay for that

    Regards, TMS

+ 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: 5
    Last Post: 07-07-2014, 06:42 PM
  2. [SOLVED] If statement that returns Active Cell to specific column if Macro is run from outside.
    By EnlightenedShadow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-31-2013, 02:09 PM
  3. Loop Until Active Cell is in a specific column?
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2013, 02:41 PM
  4. Using range with specific column and active row
    By alanb1976 in forum Excel General
    Replies: 2
    Last Post: 10-11-2011, 02:50 PM
  5. pick data from a specific row/column (eg 10/B) related to active cell
    By zonino in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-03-2009, 04:01 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