+ Reply to Thread
Results 1 to 2 of 2

Userform VBA coding help needed

  1. #1
    Registered User
    Join Date
    04-15-2011
    Location
    Llandudno, Wales
    MS-Off Ver
    Excel 2010
    Posts
    1

    Userform VBA coding help needed

    Hello all
    Im a new member just joined 5m ago and thought I would introduce myself. I am currently unemployed and doing a basic IT course through the job centre. I have used excel before but definately not an experienced user. I have been playing with vba whilst on the course and trying to adapt files from Contextures.com to my account files. I have attached a sample file. My problem is, the "money in" userform is ok and is entered in the 1st row and first cell with each additional entry on the next row. When you close that form, another form "money Out" opens up. When that form is filled, I need the 1st entry to go to Row 1 Cell 10 but it actually enters after the last entry of the "money in" form. I have tried basic edits with the numbers but realise I need help. As a learner, I would also like to be told of what changes were made and why. Any help would be appreciated. Im using Excel 2010.
    regards
    Dave
    Attached Files Attached Files
    Last edited by daibeer; 04-15-2011 at 07:27 AM. Reason: Incorrect Heading

  2. #2
    Valued Forum Contributor jwright650's Avatar
    Join Date
    12-10-2010
    Location
    Va, USA
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    606

    Re: Userform VBA coding help needed

    [edit] re: money out being placed on the wrong line.

    BTW, I only looked at July, didn't notice if other were that way or not
    You had it looking for the last used row in column 1("A"), rather than looking for the last used row in Column 10("J")

    I changed your code to this:

    Please Login or Register  to view this content.
    Also changed the "Private Sub" on Workbook Open to just "Sub", so that the workbook opens without any errors.
    Attached Files Attached Files
    Last edited by jwright650; 04-15-2011 at 08:04 AM.
    Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
    John Wright

+ 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